You probably know that database indexes are a means for improving database performance. But surprisingly few people understand the different types of indexes there are, how they work, and how to choose an appropriate index for a specific performance problem … Read more
Click here for Part 1
Chapter 3: The Select n + 1 Problem
The Select n + 1 problem describes a situation where you are hitting the database many times unnecessarily, specifically once for each object in a collection of … Read more
I intended for this article to be contained within a single post, but it turned out to be too long for that. Click here for part 2.
Over the past couple of days I have been on quite … Read more