AshimQuikStor wrote:

>
> When I execute stored procedure or any other command firebird server memory increases rapidly and is not released until the connection is broken. I have tired using parameterized queries as suggested by someone in previous lists but that does not help either.
>
> I use only one connection. After completion of any operation related to firebird, I dispose the object, but still there is no effect to the memory on server side.
>

I don't know how much memory the procedures etc. are using, but Firebird
does not release memory after operations. The assumption is that
subsequent commands will also require memory. Rather than release and
reallocate, possibly fragmenting memory, Firebird allocates from the
operating system into its own memory manager, which consolidates free
memory for reuse.

For the same reasons, and a few even better reasons, Firebird never
releases disk space.


Good luck,

Ann