On 27 Jan 2006 at 2:42, Ghazanfar Ali wrote:

> Starts the transaction
> Preparing the statement
> Executes the query using isc_dsql_execute_immediate

isc_dsql_execute_immediate does not need prepared statement.

> Freeing the statement

Are you sure that you are freeing the statament and this is the
same statement?

> memory consumed by the fbserver.exe it increases a lot. But when i
> detach from the database all the excessive memory consumed by the
> fbserver.exe is released.

Statement handles are released on disconnect. I'm afraid you are
leaking them.

--
SY, Dimitry Sibiryakov.