http://qs321.pair.com?node_id=762051


in reply to Batch INSERT performance

What database are you using? This is faster with MySQL, often by a significant margin. Even faster is LOAD DATA, but that requires some moderately annoying data formatting and error handling is harder (error ignoring is easy though!).

-sam