ADO.NET Data Services Performance Issues


Silverlight Logo

It has come to my attention that my current examples using ADO.NET Data Services are performing very badly. I was using that example as anecdotal evidence that Data Services performed slower than the Web Service counterparts.  I don't think this is accurate.  I am working on some performance comparisons that I will share on my blog once Silverlight 2 goes into a full release so I can be sure that the numbers reflect a real-world release.

The issue seems to surround a bone-headed query I was making:

var qry = from p in TheContext.Products.Expand("Supplier").Expand("Category")
          orderby p.ProductName
          select p;

This means for every product I was retrieving its related Category and Supplier.  The problem is that I was duplicating this data (since some products shared Categories and Suppliers).  Not efficient at all. 

When I re-release these examples when Silverlight 2 ships, I will be hosting the examples on CodePlex.  Watch here for announcements on the release of the code, new versions of the examples as well as the performance comparisons coming soon.

Shawn Wildermuth
Author, Teacher, and Coach

My Courses

Wilder Minds Training
Vue.js by Example (New Lower Price)
Bootstrap 4 by Example (New Lower Price)
Intro to Font Awesome 5 (Free Course)
Building an API with ASP.NET Core (New Course)
Building a Web App with ASP.NET Core, MVC6, EF Core, Bootstrap and Angular (updated for 2.2)
Less: Getting Started (New)
Using Visual Studio Code for ASP.NET Core Projects
Implementing ASP.NET Web API

Application Name WilderBlog Environment Name Production
Application Ver v4.0.30319 Runtime Framework x86
App Path D:\home\site\wwwroot\ Runtime Version .NET Core 4.6.27514.02
Operating System Microsoft Windows 10.0.14393 Runtime Arch X86