Mass Insert 1

[AP81]

I have written an application in delphi which performs a mass insert (1000+ lines). However, I am inserting each line into the table one-by-one, e.g.

INSERT INTO invoice_data VALUES (...)

Is there any way I can insert all 1000 in one go? Is this a better way to perform a mass insert?

Thanks.




------------------------------------
There's no place like 127.0.0.1
------------------------------------

 

[TonyGroves]

Certainly!

You can use:
INSERT INTO invoice_data
VALUES
( ... ),
( ... ),
( ... )
where each ( ... ) represents one record. It will be faster because you only have one query-processing operation instead of 1000.

 

[AP81]

Thanks heaps, didn't know that was possible.




------------------------------------
There's no place like 127.0.0.1
------------------------------------