vrijdag 10 februari 2006

Better performance when loading a typed dataset.

At work, we had a little performance problem when we wanted to fill a rather large typed dataset that had a number of constraints defined.

Setting the EnforceConstraints property of the dataset to false before filling up the dataset, and setting it to true afterwards, resulted in an immense performance boost.
Without setting this property to false, it took minutes to load the dataset. When we made use of this property, it only took a second or two.

Geen opmerkingen: