DataSet.Clear method is very slow

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ala - 29 Apr 2006 22:39 GMT

Hi,
How to speed up cleaning DataSet?
In my windows form application, I have many controls bound to tables in a
dataset object.
If I should unboud thes controls before calling Clear on DataSet?

Reply to this Message

Alvin Bruney - 01 May 2006 15:47 GMT

If the dataset is heavy, a clear will actually need to iterate the links
remove these objects. That takes time. I suppose you can set the object to
null. That shouldn't hurt. I'm not entirely sure what would happen if your
dataset contained unamanaged objects though.

Signature

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

> Hi,
> How to speed up cleaning DataSet?
> In my windows form application, I have many controls bound to tables in a
> dataset object.
> If I should unboud thes controls before calling Clear on DataSet?

Reply to this Message

Manoj - 23 Jul 2007 16:24 GMT

We are migrating our C#2003 project to C#2005.
We are using dataset.clear., The method seems to be very slow.
as have using inherited forms, and the dataset.clear method comes ion the base form.
Cannot make it null also.
Is there any alternate method to do this.

From http://www.google.com.bh/search?q=dataset.clear()+method+very+slow&hl=en&start=20&sa=

Reply to this Message

DataSet.Clear method is very slow

Free Magazines