General information
Category:
ActiveX controls
Title:
Set Object = Nothing Does not clear Memory
Hi All,
I am developing an application which reads records from a SQL server table and Insert the records in another Application.
Now Other Application requires to create object of data type and call the Insert method of Object to Insert data. For example Customer is Object and every time I have to create Customer Object and call Customer.Insert.
After Insert method I set object to nothing to free up memory. But during Loop I found that Set Object = Nothing just clears up object but not free memory.
This causes problem as 1000 copies of same object are created in Memory (Though in VB it is only one object).
Does VB have something to flush out object from the Physical Memory?
Thanks all..
Regards
Jiten
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only