View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 08:10 AM
Bill Karwin
 
Posts: n/a
Default Re: Why is my MySQL database so slow

Stefan Mueller wrote:
> With the following PHP script I'd like to add 2000 entries.


You should try using LOAD DATA INFILE instead of INSERT, when you're
bulk-loading lots of data.

Also read MySQL docs pages such as:

http://dev.mysql.com/doc/refman/5.0/en/load-data.html
http://dev.mysql.com/doc/refman/5.0/...ert-speed.html
http://dev.mysql.com/doc/refman/5.0/...db-tuning.html

Regards,
Bill K.
Reply With Quote