|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Fbserver.exe memory consumption increases by inserting records
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 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 Thanks in advance, With Regards, Ghazanfar. |
|
#2
|
||||
|
||||
|
You didn't even mention which version
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#3
|
|||
|
|||
|
Quote:
Firebird Version 1.5.2 OS Microsoft XP SP-2 |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Fbserver.exe memory consumption increases by inserting records |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|