distal-attribute
distal-attribute
distal-attribute
distal-attribute

import csv

User, date Message
Written by BubikolRamios
2 years ago
Category: Import/Export
327 posts since Thu, 14 Jan 10


/* 316 rows imported in 0,453 seconds. */



Would it be possible to have additional info outputed here, like:


/* 316 rows imported (out of 450 processed) in 0,453 seconds. */




Reason: the whole thing is highly unreliable, it can report no error but can happen tha large amount or rows are not imported.
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
Even better would be


/* 316 rows imported (out of 450 processed, 20 ignored due to duplictes) in 0,453 seconds. */

Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
I just started to add some "affected rows" + "processed rows" approach to the dialog, when I suddenly realize that I don't get reliable numbers from the server in most cases:
- Server parsing: LOAD DATA just returns the number of affected rows, not the number of processed rows
- Client parsing: INSERT IGNORE is the only method which gives me reliable processed and affected rows. INSERT breaks at errors, and REPLACE INTO can return 2 affected rows when one row gets overwritten due to duplicates - but as the dialog uses multiple VALUES for performance reasons I get let's say 316 affected rows, which means that some number between 158 to 316 rows were imported.

I'm afraid this keeps being unreliable.
 

Please login to leave a reply, or register at first.