Hello Everyone,
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
Preparing the statement
Executes the query using isc_dsql_execute_immediate
Freeing the statement
Commit the transaction
and perform the last five 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
Thanks in advance,
With Regards,
Ghazanfar.


---------------------------------
Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.

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