Re: [GENERAL] multirow insert

2007-07-18 Thread Dimitri Fontaine
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

Re: [GENERAL] multirow insert

2007-07-13 Thread Tom Allison
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

Re: [GENERAL] multirow insert

2007-07-13 Thread A. Kretschmer
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: -

[GENERAL] multirow insert

2007-07-13 Thread Zlatko Matić
When using multirow INSERT INTO...VALUES command, are all rows inserted in a batch, or row by row? Regards, Zlatko