Jump to content

Archived

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

Darghon

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.