Subject Re: [IBO] does a tiboquery in a prepared state consume resources on the server?
Author IB Objects
> subject line says it all. If I open an application and call prepare for
> of my queries, will this consume FB/IB server resources?

Yes, but you can make a method call which will release the handle back to
the server and leave the query in its prepared state. It will have to do the
prepare again if you attempt to open it but that shouldn't be too expensive.

There is a method called FreeServerResources (I think) that will release the
handle back. This even works for a dataset with all records fetched into

There could be a couple glitches with this feature yet so use it
carefully.... I'm still trying to make sure it is 100% effective. I have to
safeguard every possible usage of the handle and transparently restore it
and I may not have caught every angle of usage.

This is actually foundational development towards allowing even the
connection handle to go away and be brought back on demand. Functionality of
IBO v4.5.