Thread: 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