Need to suppress DataColumnCollection Events during construction of typed DataSet

[costasz]

We have a wide typed dataset and we profiled our app that constructs it
many 1000s of times and it turns out that the constructor is the most
expensive part of our app. We dug in deeper and it seems the
constructor spends most of its time in the datacolumncollection and
especially in the events that fire as columns are added. I need some
ideas on how to construct the typed dataset faster. Either suppress the
event or some other trick.

Thanks

Costas

 

[Sahil Malik]

Try calling on each individual table -

BeginLoadData,
// Do your data load here
EndLoadData.

That might help.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[costasz]

Sahil, thanks but I am not loading data yet. The constructor itself is
slow because of all the events that are firing while the columns are
added to the datacolumncollection.

Thanks


Costas

 

[costasz]

BUMP!
I need help please.

Thanks