import csv

BubikolRamios's profile image BubikolRamios posted 12 years ago in Import/Export Permalink
/* 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.
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
Even better would be

/* 316 rows imported (out of 450 processed, 20 ignored due to duplictes) in 0,453 seconds. */
ansgar's profile image ansgar posted 12 years ago Permalink
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.