Memory Leak With ADO
Posted: 03.04.2011, 13:49
Opening and closing lots of queries that point to an ADO connection (which is pointing to a MS SQL database in my case) is causing massive memory leaks. Even closing the entire connection does not free up the memory. Unfortunately, I can't modify the MS SQL database in any way to change data types or shorten field lengths since this is a customer's database.
Non-ADO connections are not showing this behavior and this also only occurs with large number of queries (>500) opened within a short amount of time - even if all queries are properly closed before opening a new one.
Any ideas??
Using the latest ZEOSLib Rev 8.78 from http://zeosdownload.firmos.at/downloads/snapshots/ with Delphi 2009
Non-ADO connections are not showing this behavior and this also only occurs with large number of queries (>500) opened within a short amount of time - even if all queries are properly closed before opening a new one.
Any ideas??
Using the latest ZEOSLib Rev 8.78 from http://zeosdownload.firmos.at/downloads/snapshots/ with Delphi 2009