At 07/06/2002 08:08 PM, you wrote:

>No, I hadn't tried either of those, although after looking again at the
>descriptions, TIB_DSQL was what I should have been using, rather than
>TIB_Cursor. I re-ran my tests using TIB_DSQL, and performance did jump, but
>I'm still getting 60% of the performance or so that I was getting out of IBX
>(On this mass insert operation.. I haven't run benchmarks of my own beyond
>that). I didn't want to try TIB_Script, because I wanted to try and get as
>close to an apples-to-apples comparison as I could.

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.


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