Re: [PHP] how to make multiple sql run faster

2009-03-22 Thread Chris
Davi Vidal wrote: 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 statem

Re: [PHP] how to make multiple sql run faster

2009-03-22 Thread Davi Vidal
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 faster Us

Re: [PHP] how to make multiple sql run faster

2009-03-21 Thread Virgilio Quilario
> Usually a single transaction is faster than an insert a time (with or without > union) > >> 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

RE: [PHP] how to make multiple sql run faster

2009-03-21 Thread Andrea Giammarchi
Usually a single transaction is faster than an insert a time (with or without union) > Date: Sat, 21 Mar 2009 12:05:18 + > From: andrew4willi...@gmail.com > To: php-general@lists.php.net > Subject: [PHP] how to make multiple sql run faster > > Hi all, > > I am

[PHP] how to make multiple sql run faster

2009-03-21 Thread Andrew Williams
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