At 07/06/2002 10:15 PM, you wrote:

> > > Give the TIB_Transaction.ExecuteImmediate method a try. Of what I see
>in
> > > the code there's no parsing and the statement is sent directly to the
> > > API. This might give you the speed you are looking for.
>
>WOW.
>I averaged between 320,000 and 330,000 records a minute.
>That's much more than the speed I was looking for (I'm not arguing, though
>:)).
>Thanks for the tip!

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.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)