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