multirow insert
When using multirow INSERT INTO...VALUES command, are all rows inserted in a batch, or row by row?
Regards,
Zlatko
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
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
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