Subject RE: [firebird-support] Firebird server occupying memory -Problem
Author Si Carter
> -----Original Message-----
> While using firebird super server we faced major memory
> problem . Our frontend side is VB.Net. When we execute stored
> procedure or any command to firebird database through vb.net
> on client side firebird super server memory is increased
> rapidly. And it does not release the memory after the
> completion of operation or executing command or stored
> procedure.We are using only one connection. After completion
> of any operation related to firebird, we dispose the object
> ,but still there is no effect to the Memory occupied by
> firebird(which should be reduced).And thus it causes our
> application to slow down.
>
> If anybody has faced a similar problem and found a solution
> .Plz let us know.

Déjà vu.

Make sure you explicitly close all FBDataReader's, Commit/Rollback
transactions and close the db connections you open.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage