yes I'm using BLOB but not that much. 1/500 transaction are BLOBs



firebird will release the memory just when i disconnect !!!!

----- Original Message -----
From: unordained
To: firebird-support@yahoogroups.com
Sent: Tuesday, October 21, 2008 11:43 AM
Subject: Re: [firebird-support] Memory Problem


---------- Original Message -----------
From: "AshimQuikStor" <ashimquikstor@...>
> firbird 2.04 and 2.11
>
> 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.
------- End of Original Message -------

From my recent experience with something similar:
- are you using BLOBs anywhere in this process?
- is the memory released only when you disconnect, or also when you commit or
rollback?

-Philip





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