BDE 5.01

redh...@mop.no (Alexander Staubo)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Extreme memory usage using image BLObs, MSSQL/BDE 5.01

TTables in D4 using BDE 5.01 accessing MSSQL tables with TEXT and IMAGE
fields use a _lot_ of memory. Why?

By "a lot" I mean in the excess of 60MB just to editing a record. The
memory seems to be temporary allocations; the memory usage goes down once
the record has been canceled/posted. The memory consumption during
viewing (ie., SELECTs) is quite abnormal, as well.

And we're not talking about _data_ here -- the memory requirement
persists even when the tables are pretty empty.

I've set BLOB SIZE=5000 in order to allow images of at least 5MB to be
stored in the tables. Maybe this is the perpetrator? Unfortunately,
storing full-resoltion images just isn't possible with the default
setting (max 32K per BLOb).

--
Alexander Staubo
http://www.mop.no/~alex/
mailto:redh...@mop.no

Other Threads

1. General SQL error with image BLObs, MSSQL+D4+BDE 5.01

2. BDE 5.01 and MSSQL 7.0

3. ODBC 12x faster than BDE 5.01 MSSQL driver??

4. Delphi 4.03 and BDE 5.01 memory leaks with Oracle 8

5. Memory Leak in Delphi 4/BDE 5.01

6. Delphi 4.03 and BDE 5.01 memory leaks with Oracle 8

7. Delphi 4.03 and BDE 5.01 memory leaks with Oracle 8

8. BDE 5.01 and memory leak with LongVarChar on MS-SQL 7

9. MSSQL: Nested querys and memory usage

10. using BDE 5.01 with SQL Server 7.0 without Microsoft Client