At 07/06/2002 09:00 PM, you wrote:

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

Hi Jason W.,

I think that for his circumstance, it seems to give him a big jump in
performance. I think for mass inserts and knowing that the insert
statement is valid and not using any parameters, this method is quick as
per the results from Jason Frey.

Maybe have the possibility in the TIB_Script to switch off the parsing and
send the statements directly to the API, IF and only IF there is no parsing
or pre-processing needed, like the statements that Jason Frey is using for
mass inserts. I think that would be a good addition to that component, so
an external script could be loaded and executed rapidly. I don't see this
switch for other components, just for TIB_Script.

Have a nice day.


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