| Subject | Re: [firebird-support] fbserver.exe memory consumption increases by inserting records |
|---|---|
| Author | Ghazanfar Ali |
| Post date | 2006-01-30T20:35:55Z |
Hello Everyone and the repliers,
I was using isc_dsql_execute previously for that i was preparing the statement, but now i am using isc_dsql_execute_immediate with no statement preperation, it has reduced the memory leaks from 80MB to 10MB for 100 records insertion. But still i am having that 10 MB leak, one thing i want to tell is that when i detach from the database all that extra memory has been properly released, but i want to keep the connection active as normally done in servers that maintaining a single connection untill someone stops the server or shuts downs the database server. please give me some solution regarding this issue, do i have to create the connection for every record insertion, or after some specific number of insertions i detaches from the database and reconnect or any other way so that i can overcome this memory leek issue. I'll be really greatfull for the help.
With regards,
Ghazanfar.
Dimitry Sibiryakov <SD@...> wrote:
I was using isc_dsql_execute previously for that i was preparing the statement, but now i am using isc_dsql_execute_immediate with no statement preperation, it has reduced the memory leaks from 80MB to 10MB for 100 records insertion. But still i am having that 10 MB leak, one thing i want to tell is that when i detach from the database all that extra memory has been properly released, but i want to keep the connection active as normally done in servers that maintaining a single connection untill someone stops the server or shuts downs the database server. please give me some solution regarding this issue, do i have to create the connection for every record insertion, or after some specific number of insertions i detaches from the database and reconnect or any other way so that i can overcome this memory leek issue. I'll be really greatfull for the help.
With regards,
Ghazanfar.
Dimitry Sibiryakov <SD@...> wrote:
On 27 Jan 2006 at 2:42, Ghazanfar Ali wrote:
> Starts the transaction
> Preparing the statement
> Executes the query using isc_dsql_execute_immediate
isc_dsql_execute_immediate does not need prepared statement.
> Freeing the statement
Are you sure that you are freeing the statament and this is the
same statement?
> 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.
Statement handles are released on disconnect. I'm afraid you are
leaking them.
--
SY, Dimitry Sibiryakov.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
---------------------------------
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]