RE: [PHP] how to make multiple sql run faster
| From: | Andrea Giammarchi | Date: | Sat, 21 Mar 2009 13:19:28 +0000 |
| Subject: | RE: [PHP] how to make multiple sql run faster | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-290483@lists.php.net to get a copy of this message | ||
Usually a single transaction is faster than an insert a time (with or without union)
> Date: Sat, 21 Mar 2009 12:05:18 +0000
> From: andrew4williams@gmail.com
> To: php-general@lists.php.net
> Subject: [PHP] how to make multiple sql run faster
>
> 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
_________________________________________________________________
More than messages–check out the rest of the Windows Live™.
http://www.microsoft.com/windows/windowslive/