Original link: Why Your .NET API Is Fast in Dev but Slow in Production / LinkedIn.
Lot of good advice. I did not even know about the .AsNoTracking() call.
I don't like the suggestion about using .Select(), because it does not work well with a OO domain model.