Hi. The page http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html says that to speed inserts: "If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time."
I implemented a solution for bibupload that combines the inserts in the bibrec_bibxxx table into one query per table. This removes around 30% of the total queries that bibupload does for a sample of our records and speeds up the process by a little bit more than 10%. Cheers. -- Benoit Thiell The SAO/NASA Astrophysics Data System http://adswww.harvard.edu/
0001-BibUpload-Combine-bibrec_bibxxx-inserts.patch
Description: Binary data
