Jump to content

Probs with mysql


Darghon

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
Link to comment
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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.