Yesterday, I was writing a Linq-to-SQL query and noticed a quite remarkable difference in performance between two very similar queries (seconds versus minutes of running time). I thought it would be worth sharing. Basically, I have a bunch of orders that are represented by two SQL tables, called Basket and BasketItem. If an order e.g.… Continue reading Strange Linq-to-SQL performance when using Count