🚀 go-pugleaf

"Clayton Arends" <nospam_claytonarends@hotmail.com> wrote in message 
news:4636005c$1@newsgroups.borland.com...
>I found time off and on during the week to test this issue.  I made two 
>test applications.  One in BCB6 and one in BDS2006 Delphi personality. 
>Both applications were built standalone.  Both applications yielded almost 
>identical results.  Memory consumption was measured using a custom memory 
>usage function and the Windows Task Manager.  I have included my BCB6 test 
>code at the end of this post if anyone wishes to double-check my test and 
>results.
>
> At one point, to rule out the VCL implementation of ADO, I rewrote the 
> test to use the raw ADO interface classes (_Connection, and _RecordSet) 
> with similar memory leak results.
>

Grateful for your effort.  Since the root cause is still a mystery, I 
rewrote the database access routine with DBExpress for trial.  I also let 
the application run over night and the test shows that using DBExpress the 
significant memory growth over time does not happen anymore.

>
> I performed some general searches for ADO memory leaks and found some 
> scattered references.  Many threads concluded that the leaks were caused 
> by misuse of the ADO objects.  Some concluded that certain versions of ADO 
> drivers were causing the leaks.  A majority had no conclusions.  It is 
> hard to know for sure what is going on here.
>

In this thread 
http://groups.google.ru/groups?hl=ru&lr=&threadm=41ed54ce%241%40newsgroups.borland.com&rnum=6&prev=/groups%3Fas_q%3DTADOCommand%26as_ugroup%3D*borland*%26as_scoring%3Dd%26lr%3D%26num%3D20%26hl%3Dru

some people said they spot the problem, while other claimed that the fix was 
already applied to Delphi 7.  But I find both my BCB6 and BDS2006 are still 
having the old code.  If anyone can kindly have a trial please let me know 
the result.  Thanks in advance.