Thread: multirow insert

multirow insert

From
Zlatko Matić
Date:
When using multirow INSERT INTO...VALUES command, are all rows inserted in a batch, or row by row?
Regards,
 
Zlatko

Re: multirow insert

From
"A. Kretschmer"
Date:
am  Fri, dem 13.07.2007, um 18:50:26 +0200 mailte Zlatko Mati? folgendes:
> When using multirow INSERT INTO...VALUES command, are all rows inserted in a
> batch, or row by row?

Within one transaction, yes.

Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: multirow insert

From
Tom Allison
Date:
On Jul 13, 2007, at 2:11 PM, A. Kretschmer wrote:

>
> am  Fri, dem 13.07.2007, um 18:50:26 +0200 mailte Zlatko Mati?
> folgendes:
>> When using multirow INSERT INTO...VALUES command, are all rows
>> inserted in a
>> batch, or row by row?
>
> Within one transaction, yes.

Trust me... It's MUCH faster then trying to do each insert.

I have a little program that was a 100x improvement in performance by
changing my SQL to use INSERT INTO ... VALUES


Re: multirow insert

From
Dimitri Fontaine
Date:
Le samedi 14 juillet 2007, Tom Allison a écrit :
> On Jul 13, 2007, at 2:11 PM, A. Kretschmer wrote:
> > am  Fri, dem 13.07.2007, um 18:50:26 +0200 mailte Zlatko Mati?
> >
> > folgendes:
> >> When using multirow INSERT INTO...VALUES command, are all rows
> >> inserted in a
> >> batch, or row by row?
> >
> > Within one transaction, yes.
>
> Trust me... It's MUCH faster then trying to do each insert.

Or read this article about the case:

http://www.depesz.com/index.php/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/

Regards,
--
dim

Attachment