Article View: borland.public.cppbuilder.database.dbexpress
Article #115Firebird memory usage is increasing using dbExpress
From: Facundo Fierro
Date: Fri, 29 Oct 2004 23:32
Date: Fri, 29 Oct 2004 23:32
25 lines
1883 bytes
1883 bytes
I have a problem with a client server application that I create using dbexpress with c++builder. The application is runing all the time and is geting slowler in two hours working. I noticed that the memory usage is increasing. At the begin it was in 15.000 KB and in some hours it was in 80.000 KB and the some storeprocedures were working slow. I'm using Firebird 1.5 Superserver. The application connects to the server from 5 PCs. When I close the applications and reopen them the memory goes to 15.000 KB, and the application runs fine. I think It may be somethig related with transactions that remains open with dbexpress. I have some queries using ClientDataSet that I close and reopen when there is a change in the table. But perhaps this way the transaccion remains open consuming a lot of memory, Is it posible? What can I do to identify the problem? Should I start and close transactions in my source code? Thanks for your help.
Technical Details
Message-ID:
<4182ef3e$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,e1aeba7beb095eb2,start X-Google-Attributes: gidfb4e2,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Facundo Fierro" <ffierro@nextview.com.ar> From: "Facundo Fierro" <ffierro@nextview.com.ar> Newsgroups: borland.public.cppbuilder.database.dbexpress Subject: Firebird memory usage is increasing using dbExpress Date: Fri, 29 Oct 2004 22:32:51 -0100 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 200.43.231.127 Message-ID: <4182ef3e$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1099099966 200.43.231.127 (29 Oct 2004 18:32:46 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail