Posted by Sean on 12/05/05 13:59

If you are using mysql instead of using INSERTS you should save the
data to a file and then use the LOAD DATA statement it will speed
things up considerably. LOAD DATA is about 20 times faster than INSERT.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

However since you have mentioned very little about the problem I dont
know if this will help.

• Next in forum: Write a file from mySQL BLOB
• Prev in forum: Re: Smarty and template alternatives
• Thread view: Re: Need help getting a script for huge inserts

[Reply to this message]