I believe it is best if you use a prepared TIB_DSQL statement with an INSERT
INTO statement. This makes it so the server doesn't have to do the parsing
for each item sent. It just operates on buffers easily transferred in a
described state.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, June 07, 2002 4:30 PM
Subject: Re: [IBO] Newbie Question -- Inserts slow?


> 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)