Re: multirow insert

[Tom Allison <tom@xxxxxxxxxxx>]

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