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.