There is a tradeoff. I say keep prepared those queries that are used on a
rather frequent basis. If they are only used infrequently or in a process
that isn't performance sensitive it would make sense to not keep them
prepared.

Also, since IBO does nothing to automatically Unprepare statements it would
be a good idea if ever there are things you do that you know are done for a
while to include code to explicitly unprepare the datasets and/or
statements.

It would be very interesting if you did some benchmarks and comparisons on
this.

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

----- Original Message -----
From: "Aage Johansen" <aagjohan@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 10, 2001 2:14 PM
Subject: [IBO] Lots of TIB_Cursors/TIB_Queries


> Is there a penalty for having a DataModule with a _lot_ of TIB_Cursors
> (most or all of which are prepared) - memory requirements or other issues?
>
> I have 50+ SQL queries that I use for validating input data. Currently I
> use just a few TIB_Cursors where I replace the SQL
> (Clear/Add/Prepare/... plus links) all the time. I would guess that
> having separate TIB_Cursors which are kept prepared would be somewhat
> faster, but have not yet tried this approach.
>
> TiA
> Aage J.
>
>
>
>