in reply to Re^2: DBI Question: bulk insertion with Unique-key constraint
in thread DBI Question: bulk insertion with Unique-key constraint

Yes, doing a pass on the CSV file with perl and generating another CSV file to pass to MySQL is still probably faster than loading it row by row.

By the way, INSERT IGNORE or INSERT ON DUPLICATE UPDATE are both typically faster than REPLACE if you do need to do it row by row.

  • Comment on Re^3: DBI Question: bulk insertion with Unique-key constraint