Subject Re: [IBO] Newbie Question -- Inserts slow?
Author Jason Frey
> Just remember, it works with the type of INSERT statements that you are
> using and know that they work. And that, you wouldn't be able to use an
> INSERT statement with parameters or any other statement that you would be
> expecting a result back. Also, just for comparison purposes, try
TIB_Script.

I got the following results by averaging three runs of each, with a
delete/commit between each run, so it was always inserting into a 0 record
table.
IBScript averaged 2 minutes 20 seconds to run through my 366,424 insert
statements.
Using ExecuteImmediate, average over three runs was 1 minute 10 seconds.

- Jason