When working on database powered application, often performance issues come from: N+1 queries. Where we have a list of records, and we make extra queries for each record. Performing expensive count queries. Often, those queries need to do the whole table reads.