Multiple "INSERT INTO.." in one ExecSQL?
lazarus / 16-Databases

----------------------------------------------------------------------
tatamata · 2008-09-15 09:11

Hi!
1. Is it possible to execute multiple INSERT INTO table (fields)
VALUES (..), using Zeoslib and how?
2. I have a procedure which dynamically creates SQL string "INSERT
INTO" and executes it for every row seperately. If I generate SQL
strings first for all rows and the execute multiple "INSERT INTO.." in
one step, would it increase performance?

----------------------------------------------------------------------
bobo · 2008-09-15 23:33

For MySQL you can do

INSERT INTO table (fields) VALUES (..), (..), (..), (..), (..), (..);

as one SQL statement. This should be the fastest.
Not sure about other databases.

----------------------------------------------------------------------
tatamata · 2008-10-01 17:25

What about Firebird?
UNION ALL, maybe?