Best way to release Memory used by Datasets

[S Anand]

Hi,

We are using vb.net in our "windows application" and are using datasets
heavily (100s of them). We declare them in our methods and use them and
currently are not doing anything to specifically dispose or reclaim memory.

What is the best way to dispose them and reclaim memory. We are fine even if
the GC collects them properly after a certain time. We just do not want the
datasets to be sitting in Memory after their usage is complete.

Does the VB GC take care of this automatically ? or should we do something
specific like assigning DS = Nothing or using DS.dispose() etc.

Thanks a lot for your responses.

S Anand

--
- Anand

[Cor Ligthert [MVP]]

S Anand,

If you use Net or any other modern way that uses a GC, than you should allow
that memory is released in a time that it is the best for the performance.

What is the reason that you want to free memory that you don't need?

In my opinion is the way you do it now, just fine.
Assuming the code is completly inside the method this
\\\
Dim ds as new dataset
////

I hope this helps,

Cor

[S Anand]

> S Anand,

If you use Net or any other modern way that uses a GC, than you should allow
that memory is released in a time that it is the best for the performance.

What is the reason that you want to free memory that you don't need?

> Reason being to ensure that our application runs at optimal speed. If something is not needed , I want to ensure that it will be collected at the next GC cycle.
> Also, I read that DAtaset is an Unmanaged object (along with db connections and some others) . So need to know whether we need to code something specific

In my opinion is the way you do it now, just fine.
Assuming the code is completly inside the method this
\\\
Dim ds as new dataset
//// Some of our datasets are created and passed around to multiple methods as parameters. Some are declared in the Windows Form declaration section and used all over the form.

So, I want to ensure that after we close the form, these are marked for
release properly and so want to know if there is any specific way to do this.

[Cor Ligthert [MVP]]

S Anand,

>> Also, I read that DAtaset is an Unmanaged object (along with db
>> connections and some others) .

Can you show us where?

As you create your dataset global, and you are sure not reusing (and than
the old one looses his reference so it goes automaticly to nothing) than you
can set it to nothing to tell the GC when it starts that it has no
references anymore. (In my opinion has this only sense with real huge
datasets)

I hope this helps,

Cor

[M. Posseth]

in my opinion the easiest way is to write all your data handling in methods
( all objects declared in a method ) this way it will be market for
collecting when the method has finished ( fastest \ easiest way ) without you
having to wite extra code for it

regards

M.Posseth

"Cor Ligthert [MVP]" wrote:

S Anand,

>>> Also, I read that DAtaset is an Unmanaged object (along with db
>>> connections and some others) .

Can you show us where?

As you create your dataset global, and you are sure not reusing (and than
the old one looses his reference so it goes automaticly to nothing) than you
can set it to nothing to tell the GC when it starts that it has no
references anymore. (In my opinion has this only sense with real huge
datasets)

I hope this helps,

Cor