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.

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?



I am developing a client/server application where server has to insert a lot of records in the database. I am using firebird as my database server. But i have found some problem with fbserver.exe that when i insert records the memory consumed by the fbserver.exe increases. If i insert 100 records with the single connection fbserver.exe memory consumption reaches from 4MB to 90MB. The basic procedure to insert records i used is:
Make A Connection With the database
Starts the transaction
Executes the query using isc_dsql_execute_immediate
Commit the transaction

and perform the last three steps multiple times and if i check the memory consumed by the fbserver.exe it increases a lot. But when i detach from the database all the excessive memory consumed by the fbserver.exe is released.

I want to know that does it always happens because it will cause a lot of problem in my case because my server is maintaining the single connection with the database and keep on inserting. but as the memory consumption increases the OS will be outof memory after sometime. Please anyone help me out from this problem. Ill be very thankfull. It will be a great help if some one tell me the solution for this memory consumption by the fbserver.exe


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