in reply to Caching and inserting big number of records
That said, if you can collect all of your data, then do a bulk insert, then using LOAD DATA INFILE with indexes turned off is supposed to be 20 times faster than using INSERT statements. This does require you to format your data in CSV, for which you can use Text::CSV_XS
Clint
|
|---|