I was running into an issue where one of my webmethods was taking a large amount of time to return a small set (5-10 objects). I was using LINQ to SQL. I noticed that the LINQ to SQL query was returning all of the rows. After looking into the table a
Read More...
Read the complete post at http://feeds.feedburner.com/~r/JasonNGaylord/~3/309300217/performance-tip-return-only-necessary-columns-using-linq.aspx