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
Usually 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 much
davi
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
