import csv

BubikolRamios posted 6 years ago in Import/Export
/* 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 posted 6 years ago
Even better would be

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