Yes, I did think of the unidirectional property (not the first time though!)
and request live is also false.
It is BDE 5.01, Interbase 5.1, and NT. When I get a chance in the next while
I'll try reproducing it with a simple program.
Andrew.
> -----Original Message-----
> From: Max Renshaw-Fox [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 02, 1999 5:46 PM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: BDE Added Value
>
> Hi Andrew,
>
> I was being slightly tongue-in-cheek. However you raise a valid point, as
> I
> see it - it's horses for courses. I like the BDE, and Interbase for that
> matter, because my main market is proprietary mid-sized development - at
> which they both excel. If I was doing a shrink-wrap, or more likely for
> me,
> modular Client-Server product I would seriously consider an alternative
> that cuts out the middleperson. If multiple back-ends is important I'd be
> back to the BDE again (Softech [sp?] use IB and Oracle and handle both SQL
> syntaxes fairly cleverly).
>
> I would also urge you to seriously consider putting some effort into
> reproducing the memory leak in a small dedicated app, for sending to
> Borland - er Inprise - er Borland.com. I'd be happy to help, - it should
> be
> BDE501 on IB5x though. I've done some fairly large tests against IB, on
> randomly generated data, without any issues - but not from "real" data.
>
> One simple thing comes to mind - if the TQuery thinks it has to have a
> bi-directional cursor it will try to cache the records you have scrolled
> through so that you can change you mind at the 4.49 millionth record and
> start going Prior instead of Next. Did you have RequestLive to False and
> UniDirectional to True?
>
> Max
>
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Cooke, Andrew
> > Sent: Tuesday, 2 March 1999 12:21
> > To: Multiple recipients of list delphi
> > Subject: [DUG]: BDE Added Value
> >
> > I wrote a little Delphi program to dump data from a stored procedure
> > select
> > in Interbase to a text file.
> > We ran it on a database with about 4.5 Million records.
> >
> > After about 500,000 records it crashed - the machine had run out of
> > virtual
> > memory (only had 128Mb of physical ram, and 178 of swap). We set the
> swap
> > file to 500Mb and ran it again. This time we got to the 2 Million record
> > mark before running out of virtual memory. We watched memory use in task
> > manager and it was increasing by about 300kb per minute!
> >
> > After looking hard at my simple program, and trying various options with
> > it
> > and Interbase, we dumped TQuery and instead used the FreeIBComponents
> > (avoids the BDE). Result? Without changing the program (just subsituting
> > components), the software dumped out the 4.5Million records in no time
> > flat
> > WITHOUT any increasing memory allocation.
> >
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
