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?
Probs with mysql
1 reply to this topic
Posted 02 August 2006 - 02:49 PM
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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users