How to dispose of all datasets to save memory space?

Question

hi How do I dispose a dataset or datatable after it is being used? is it dataset.Dispose(); How do I dispose the garbage collector of all datasets that are used previously? is it GC.Collect(); but it does not work.

Andrzej Wegierski · Answer

So Dispose() for all Connections (see help) DataSets and another objects which could keep DataSets next GC.Collect() I think ... and test memory with GC.GetTotalMemory(). My knowledge about GC isn't large.

sunspotzzz · Answer

Hi It is because I am preprocessing the database for futher use. I am researching on Approximate Aggregate Querying and this is my final year project.

Andrzej Wegierski · Answer

Another view: why do You use all the big database at once? May be it can be split into smaller pieces for computations etc. It would be much more faster.

sunspotzzz · Answer

Hi It is beause I am using a very big database and from what i know GC will only empty itself when it is at the limit and GC can no longer hold anymore. Further more GC will not empty all the trash. Is it true?

Andrzej Wegierski · Answer

You don't need to do it; GC is doing it quite smart. But I know about error on DataView: it doesn't free memory after use when is redefined. Try not to re-set DataView filters or sort but create new instead.