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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to