Board index » delphi » HELP: BDE doesn't free Memory

HELP: BDE doesn't free Memory

Hi all,

we are developing a database-application for Win95 with Delphi 2.0
using local Paradox-tables through the BDE. We write datasets into our
database with TQuery.Append and .Post.

The problem is that the BDE allocates Windows-memory on every
write-access which is only deallocated when the application
terminates. (The application consumes ~70 MB of virtual memory
easily!)

What's our fault? Can anyone help?

Thank you,
Carsten Labinsky.

--
 _______ ___ ___ ____________________________________________________________
|       /  //  /                                                             |
|      /  //  /  InterNet  : Carsten.Labin...@Informatik.Uni-Oldenburg.De    |
|___ _/_ //  /   Snail-Mail: Carsten Labinsky, Sachsenstr.94,                |
|\  \\  \/  /                26121 Oldenburg, Germany                        |
| \   \    /     Phone     : ++49 441 882017, ++49 441 9722120               |
\__\__/\__/__________________________________________________________________/

 

Re:HELP: BDE doesn't free Memory


<<The problem is that the BDE allocates Windows-memory on every
write-access which is only deallocated when the application
terminates. >>

Are you creating Queries on the fly wth
MyQuery:=TQuery.Create(Application)?????

try MyQuery:=TQuery.Create(nil) and explicity dispose of it yourself.

TQuery.Free.

Trust me you are not disposing of stuff in a timely manner!
  E-mail from: Steve Garland,Hyper Logic Resource Group http://netnow.micron.net/~sgarland
  Hyper Bill of Materials (HBOM), Manufacturing Scheduling System (MSS)   (English & Spanish)
  Delphi Corel Visual CADD (tm)Component (HVCADD)- View and Manipulate AutoCAD (c) DWG Files

Re:HELP: BDE doesn't free Memory


On Thu, 17 Apr 1997 13:07:33 GMT, "Carsten Labinsky"

Quote
<Carsten.Labin...@Informatik.Uni-Oldenburg.DE> wrote:
>Hi all,

>we are developing a database-application for Win95 with Delphi 2.0
>using local Paradox-tables through the BDE. We write datasets into our
>database with TQuery.Append and .Post.

>The problem is that the BDE allocates Windows-memory on every
>write-access which is only deallocated when the application
>terminates. (The application consumes ~70 MB of virtual memory
>easily!)

>What's our fault? Can anyone help?

>Thank you,
>Carsten Labinsky.

>--
> _______ ___ ___ ____________________________________________________________
>|       /  //  /                                                             |
>|      /  //  /  InterNet  : Carsten.Labin...@Informatik.Uni-Oldenburg.De    |
>|___ _/_ //  /   Snail-Mail: Carsten Labinsky, Sachsenstr.94,                |
>|\  \\  \/  /                26121 Oldenburg, Germany                        |
>| \   \    /     Phone     : ++49 441 882017, ++49 441 9722120               |
>\__\__/\__/__________________________________________________________________/

This sounds similar(same symptoms) to a problem we are having except
that the BDE gives an" Insufficient Memory for Operation" error then
an acess violation. We upgraded from BDE 3.0 to 3.5 but now we get a
GPF in Kernel32.dll(invalid page fault caused by our application). We
have been using Memory Sleuth and it shows that when our application
grows to about 690K under BDE 3.0 it crashes. With BDE 3.5 it will
grow to about 808K then causes a page fault in Kernel32.dll.
I would like to hear your thoughts.
stev...@meretek.com

Other Threads