Re: how to make multiple sql run faster

[Davi Vidal <davividal@xxxxxxxxxxxxxxxx>]

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