Memory usage

[Claxer]

I have created an application that uses a database with many different recordsets/tables. During the running of my app i notice the functionalities are getting slower. I am thinking that I maybe using up the RAM with my variables and controls etc....

I thought i was fushing out the mem by using the code: Set rsRecordVar = Nothing

Is there a way I can measure the amount of RAM a particular variable/control is using at one time. Just to allow me to identify the code area that causing the slow down.

Thanx

clax

[mlewis]

With VB comes a handful of tools, including Process Viewer, Heap Walker, Spy++, etc. By using a combination of them, you can figure out how much RAM your app uses. It has to be an EXE or DLL to work properly.

Use either Process Viewer or the App.hInstance property to get a PROCESS ID for your program. Then go to heap walker, and find your process in the list. It will show all data allocated. Watch this list and refresh it often to see how that all changes.

[Claxer]

I didnt know about the apps u mentioned - ill have a look

thanx again