Recently, I ran a test to see how long it would take to load about 100,000 records into a collection from DAO in Access. The process was adequate (less than 10 seconds).
Each record was loaded in to an object I defined from a Class; then stacked into a collection as the records were read in.
Everything worked great until I tried to quit the application. Access was extremely slow in freeing the memory it had eaten from creating the objects in the collection. It took about 15-20minutes for the app to free all its memory and shutdown.
Does anyone know of a faster way of freeing this memory besides setting the collection to "Nothing"? Some neat Windows API technique or something?
Any assistance is appreciated.
Gary
gwinn7
Each record was loaded in to an object I defined from a Class; then stacked into a collection as the records were read in.
Everything worked great until I tried to quit the application. Access was extremely slow in freeing the memory it had eaten from creating the objects in the collection. It took about 15-20minutes for the app to free all its memory and shutdown.
Does anyone know of a faster way of freeing this memory besides setting the collection to "Nothing"? Some neat Windows API technique or something?
Any assistance is appreciated.
Gary
gwinn7