Well Max, I agree and I disagree. If your software was going to be shipped
to millions of users, I would guess that you would stress test it and run
something like boundschecker to test for memory leaks. Perhaps I've struck
something outside the 95% level for defect testing - such as using a
database such as Interbase which is perhaps not used often with the BDE, or
perhaps doing a simple select rather than complex updates and deletes. I've
used the BDE on a number of projects without problems, and I _do_ appreciate
its back-end independance, although any project where I've had to change
databases has actually required significant rethink and rework anyway. And I
don't intend for this to degenerate into the usual round of BDE knocking.
However, I would imagine that a memory leak of this size is fairly
significant. Perhaps its something I should report to Inprise directly...
Andrew.
> -----Original Message-----
> From: Max Renshaw-Fox [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 02, 1999 12:56 PM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: BDE Added Value
>
> So your saying the BDE is designed for back-end independence and *normal*
> application development rather than bulk loads?
>
> 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
>
>
> Hi,
> Seeing BDE alternatives has come up again, I just thought I'd let you all
> know about some "added value" we got from the BDE...
>
> 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.
>
> Hmm, guess where our "added value" was coming from?
>
> Regards,
> Andrew.
>
> ----------------------------------------------------------------
> Andrew Cooke, Software Engineer ([EMAIL PROTECTED])
> Information Technology Services, AgResearch, Ruakura Research Centre
> Private Bag 3123 Hamilton, New Zealand. +64-7-8562836, fax +64-7-8385117
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
