Darghon Posted August 2, 2006 Share Posted August 2, 2006 Ok so I have this page that needs to create around 40400 records in a mysql DBIf 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted August 2, 2006 Share Posted August 2, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.