import csv
| User, date | Message |
|---|---|
|
Written by BubikolRamios
1 year ago Category: Import/Export 273 posts since Thu, 14 Jan 10 |
Would it be possible to have additional info outputed here, like:
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
1 year ago 273 posts since Thu, 14 Jan 10 |
Even better would be
|
|
Written by ansgar
1 year ago 3950 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. |