Multiple INSERT INTO

[tatamata]

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?

[mdaems]

For scripts there is the ZSQLProcessor component. Just write the sqlscript in a string. Set the Script property (just once, that should be more efficient than adding line by line). Call the execute method.
Not sure if it would increase performance. Statements would be fired one by one to the database anyway.

Mark