Jump to content


This topic is now archived and is closed to further replies.


Probs with mysql

Recommended Posts

Ok so I have this page that needs to create around 40400 records in a mysql DB
If I execute every sql statement seperately the page takes about 15 min to load.
To save loadtime, I'm trying to execute ALL 40400 sql query's at the same time.
Like this =>

INSERT INTO [table][tr][td]([fields]) VALUES([values]); INSERT...

The sql statement works on a mysql monitor. but guess what => it doesn't work on a php webpage...
any way to fix this, or a work around way...

or even other methods to reduce load time?

Plz help

Share this post

Link to post
Share on other sites
First, you can use a multi-valued INSERT statment, so that you don't have to issue to many inserts (though 40K might be too many, depending on the max. packet size).  Second, I don't know what you mean about => not working.  Also, you can use INSERT DELAYED.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.