ADO Memory Leak (BLOB fields)?

Dan English

Delphi Developer

Tue, 06 Apr 2004 00:58:50 GMT

ADO Memory Leak (BLOB fields)?

I am trying to append 50,000 records to a SQL2000 database (uses MDAC 2.6)
from a Delphi 5 (with all update packs) app. The database has one BLOB
field (generally about 100k in size).

The problem is... the app increasingly uses more and more RAM during the
process. If I comment out the BLOB updating code, it does not use the RAM.
Closing the dataset, or even the app does not release the memory. Is this a
known problem with ADO? Any solutions?

Thanks,

Dan English
d...@defined.net

Dan Englis

Delphi Developer

Tue, 06 Apr 2004 04:15:11 GMT

Re:ADO Memory Leak (BLOB fields)?

My mistake... I have SQL Server running on the same box... IT was eating up
the extra memory!

-Dan

Other Threads

1. ADO Recordset : Big Memory leak about Field->set_Value( )

2. Memory Leak on Retrieval of Blob

3. BDE BLOB SIZE, memory leak

4. Memory leak with blobs and TIBQuery?

5. Memory leak with ADO dataset and append/post

6. ADO Memory Leaks

7. ADO Connection causes memory leaks

8. Memory Leaks w/ ADO

9. Memory Leak with ADO/Access

10. ADO ?Memory Leak