Subject Firebird Memory release problem
Author patelsop_05
Respected Sir,

While using firebird super server we faced major memory problem. Our
front-end side is VB.Net. When we execute stored procedure or any
command to firebird database through 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.

We have tested firebird on server side and memory occupied by the
server keeps on increasing till the processes of the application
connected to the server is stopped.

A major observation during our testing was that for certain processes
the memory increases rapidly and keeps on increasing. It happens at
only some of events of application not in all events. What could be
the major cause for the fluctuation in the server memory consumption?

System configuration:

Windows XP Professional Service Pack 2 (build 2600)
Processor: 3.00 gigahertz Intel Pentium 4
16 kilobyte primary memory cache
2048 kilobyte secondary memory cache
Memory: 504 Megabytes Installed Memory
Slot 'J6G1' has 512 MB
Firebird Version: 1.5.1 win32
Firebird .Net Provider Dll version : (runtime version:


Pranav Patel