Merill Fernando

Principal Product Manager @ Microsoft Entra

less than 1 minute read

Andrew Conrad writes about Dataset performance improvements in .NET 2.0. For me these improvements are really, really good reasons to switch to .NET 2.0 as soon as it ships (or even earlier when a ‘Go Live’ license is available).

System.Data.DataSet contains some very significant performance improvements over prior versions – particularly for large result set scenarios.

In particular,

  • Highly efficient Binary Remoting --  For large Dataset, orders of magnitude better than v1.x
  • Row Insert, Delete and Modify operations – For large Dataset, orders of magnitude better than v1.x. For instance, for a DataTable with PrimaryKey constraint, inserting million rows in random order takes around 45 seconds. Everett took 30 Minutes.
  • Maintaining DataViews in sync with underlying DataTable was very expensive in v1.x, In Whidbey it’s extremely fast – orders of magnitude better.
  • WebServices/Remoting for TypedDataset: It can be send across to other end without having to send its schema, significantly reducing the serialized payload and giving approx 4x+ improvement in end-end latency.

The following article (in addition to highlighting some new V2 features) also details the performance improvements.

Categories:

Updated:

You may also enjoy

Device filter > Device platform

less than 1 minute read

When designing a conditional access policy and have the choice between using device filter and device platform always use device filter.

What I use

less than 1 minute read

I’m frequently asked about the apps I use. So here’s a list for future reference so I can avoid repeating myself 😀