Multiple INSERT INTO
Posted: 19.09.2008, 13:18
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?
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?