You can close queries without doing an unprepare. If you Unprepare a query it is also closed. Thus, you can think of
Unprepare as a closing of the query, a release of all buffers and a release of the statement handle to the server.

Jason Wharton

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------

On Thursday 11 March 2004 4:38 pm, jwharton@... wrote:
> to remain prepared. Just keep in mind if you keep a statement prepared
> there are various client memory structures (blobs and record buffers) that
> will not be freed (even if a query is closed). By doing a periodic
> unprepare of your statements and datasets will keep your client memory from
> being used up.

Does this mean that for any and all applications I need to unprepare queries
before I close them? Does this (blob and record buffer) memory every get
freed automatically, for example when I close / destroy the connection?

Thanks,
Tim