Hi,

I am using ADO 2.0 in one of my application. One Ado connection has opened in form_load event and in one timer I am checking the entries in one of the table in every 100 ms interval. I am using the following code in the timer

Private timer1_timer()
dim LRST as adodb.recordset
set lrst=new adodb.recordset
lrst.open "select * from table",gc_connection,adopendynamic
do while not lrst.eof
   call process_data(lrst!id)
   lrst.movenext
loop
lrst.close
set lrst=nothing
end sub

The memory usage for this program is increasing time to time. After 24 hours I could see a major increase in the memory usage. While seeing this problem I upgraded my ADO to 2.8. Still I couldn't see any change in memory usage.

What may be the reason?

Any help would be appretiated.

Seeja

Hi,
I'm no expert in this area...but my first guess would be that your not giving enough time(100ms = 1/10 of a second) for the code in your timer event to execute. Time your code(let me know if you need help with that) then set your interval in the timer accordingly.