Memory and cursors

Article View: borland.public.cppbuilder.database.multi-tier

Article #924

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#924

From: Joe Abbeduto
Date: Tue, 22 Aug 2000 00:00

12 lines
1115 bytes

I have an app built in bcb 4 that retrieves 30,000 + rows from a MS Access
database.  As the processing goes on it consumes more and more memory until
it hangs.  As a test, I ran thru a couple of thousand records and then
closed my query, and the memory utilization dropped.

Is there a setting somewhere or a method (I would prefer a method) that I
can use that will minimize the size of the buffer used to retain the cursor,
so that memory will be freed?

Any help would be greatly appreciated.

Joe

Technical Details

Message-ID: <8ntvsj$lmt8@bornews.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,f17a1da445341118,start
X-Google-Attributes: gidfcd2b,public
From: "Joe Abbeduto" <joe@circuitvision.com>
Subject: Memory and cursors
Date: 2000/08/22
Message-ID: <8ntvsj$lmt8@bornews.borland.com>
X-Deja-AN: 661132322
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
X-MSMail-Priority: Normal
X-Priority: 3
Content-Type: text/plain; charset="iso-8859-1"
Mime-Version: 1.0
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Newsgroups: borland.public.cppbuilder.database.multi-tier