Re: how to make multiple sql run faster
| From: | Davi Vidal | Date: | Sun, 22 Mar 2009 12:53:10 +0000 |
| Subject: | Re: how to make multiple sql run faster | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-290528@lists.php.net to get a copy of this message | ||
On 03/21/2009 10:19 AM, Andrea Giammarchi wrote:
Hi all, I am inserting more than 5000 rows into sql database but its taking more than 30 mins to get it all the data inserted. I use union to insert multiple rows of 20 at a time. What is the best way to make insert sql statement run fasterUsually a single transaction is faster than an insert a time (with or without union)
What do you mean?START TRANSACTION; INSERT; INSERT; INSERT; COMMIT;
Is that?
Thank you very muchdavi