🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.dbexpress
Article #115

Firebird memory usage is increasing using dbExpress

#115
From: Facundo Fierro
Date: Fri, 29 Oct 2004 23:32
25 lines
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-mail

Show 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