|Subject||Re: [IBO] does a tiboquery in a prepared state consume resources on the server?|
> subject line says it all. If I open an application and call prepare forall
> 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