Re: TDataSet memory occupation

Article View: borland.public.cppbuilder.database.ado

Article #624

Back to borland.public.cppbuilder.database.ado Previous Next

#624

From: Giuliano
Date: Fri, 28 Oct 2005 17:17

28 lines
1777 bytes

On Fri, 28 Oct 2005 18:39:43 +0200, "luca" <lct@tele2.it> wrote:

>opening a TDataSet connected to a big table (40MB) the memory occupation of
>the process grows of the same quantity.
>is possible to avoid this?
>
>luca
>

You can try to use a "server side" cursor.  

A server side cursor fetches only one row 
(or a little number of rows) at each call.

By contrast, a "client side cursor" it makes 
the attempt to fetch all the rows of the 
relation/table. If the cardinality of the 
retrieved set is large, you can have a huge 
memory requirement.

The steps to obtain the desired behaviour
they depends on the technology you are using  
(i.e. if you are using ADOExpress, IBExpress, 
dbExpress,  etc etc).    

Regards    

Giuliano

Technical Details

Message-ID: <1km4m1hfj77kq52grfvjp21t2eucj0bbh1@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsread.com!news-xfer.newsread.com!nntp.abs.net!newsfeed.cw.net!news-FFM2.ecrc.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!solnet.ch!solnet.ch!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <43625421@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,f4d1868d4c236c15
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Giuliano <giuliano@ remove .zofm.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: TDataSet memory occupation
Date: Fri, 28 Oct 2005 19:17:37 +0200
Message-ID: <1km4m1hfj77kq52grfvjp21t2eucj0bbh1@4ax.com>
References: <43625421@newsgroups.borland.com>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.72.236.131
X-Trace: newsgroups.borland.com 1130519858 81.72.236.131 (28 Oct 2005 10:17:38 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsread.com!news-xfer.newsread.com!nntp.abs.net!newsfeed.cw.net!news-FFM2.ecrc.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!solnet.ch!solnet.ch!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message