how to make multiple sql run faster
| From: | Andrew Williams | Date: | Sat, 21 Mar 2009 12:05:18 +0000 |
| Subject: | how to make multiple sql run faster | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290479@lists.php.net to get a copy of this message | ||
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 faster
--
andrew
www.willandy.co.uk