Subject | Re: [IBO] Newbie Question -- Inserts slow? |
---|---|
Author | Jason Frey |
Post date | 2002-06-08T13:47:17Z |
> Just remember, it works with the type of INSERT statements that you areTIB_Script.
> 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
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