Free all memory from program?

[kandieman101]

I am working on a program that is memory-intensive, and although I will be going through trying to make it as effecient as possible, I believe it will still use a lot. It will need the ability to restart, and therefore *basically* perform the same thing with different data again.

Is there anyway I can "clear" all data from the memory currently associated with the program, or ANYTHING that would help me out... thanks!

[James Stanich]

This is somewhat vague...

Are you using arrays?

Erase ARRTEMP

Unload All Form when Exiting program

Dim Frm as Form
 
For Each Frm in Forms
 
Unload Frm
 
Set Frm=Nothing
 
Next
 
End

Are you using connections and recordsets (databases access)

Rst.Close
 
Cnn.Close
 
Set Rst = Nothing
 
Set Cnn = Nothing

Wher rst is your recordset object, and cnn is your connection string object...

[kandieman101]

Actually, it is a module that has rougly 25+ variables, is there anyway I could, in theory "erase" the module then reload it?

Thanks for your help so far, it has gotten me someway...

[wpearsall]

Originally posted by James Stanich

Are you using arrays?

Erase ARRTEMP

Just wondering..

I split my "Retrieved Data" from a "Winsock1" control, into:

DataArray()

I Can get rid of everything in "DataArray()" by:

Erase DataArray()
' OR
Erase DataArray(0) ' (1) (2) ETC

, And you have to close record sets too, before you:

Set myrs = Nothing

?

: Learn something everysecond here huh

[kandieman101]

Nice to know... but does anyone have any info on how I can like quickly erase 25+ variables from the ram!?

[James Stanich]

Are the global variables, form level, or procedure level?

Seeting frm = Nothing should release from and procedure level. Globals I never could get confirmation on how to perform, so I used arrays whenever possible...

[kandieman101]

I have variables on different scopes, I just want to free up as much ram as possible whenever possible.