BUT sometimes my firebird get 2GB of memory, it makes the system very slow.

----- Original Message -----
From: Ann W. Harrison
To: firebird-support@yahoogroups.com
Sent: Tuesday, October 21, 2008 12:27 PM
Subject: Re: [firebird-support] Memory Problem


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




[Non-text portions of this message have been removed]