Jump to content


Photo

Probs with mysql


  • Please log in to reply
1 reply to this topic

#1 Darghon

Darghon
  • Members
  • PipPipPip
  • Advanced Member
  • 83 posts

Posted 02 August 2006 - 11:33 AM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

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