[Firebird-net-provider] fbserver.exe eats up all memory

[Ketul Patel]

my superserver fbserver.exe does not release memory even after its done processing queries. It just keeps on increasing with each processing until the PC is out of memory.

I am designing DM application with VB.Net as front-end and super server architecture as db. I use .net provider v1.7.0.38081.

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.

Any clue or experience will help?

System configuration:
 

Windows XP Professional Service Pack 2 (build 2600)
Processor: 3.00 gigahertz Intel Pentium 4
Memory: 504 Megabytes I nstalled Memory

Firebird Version: 1.5.1 win32
Firebird .Net Provider Dll version: 1.7.0.38081
Framework: v1.1.4322

db Page size – 8K

----------------------------------
Ketul