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 Link to comment https://forums.phpfreaks.com/topic/16314-probs-with-mysql/ 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. Link to comment https://forums.phpfreaks.com/topic/16314-probs-with-mysql/#findComment-67838 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.