home/categories/sql-databases/aaronontheweb-dotnet-skills-skills-database-performance-skill-md
sql-databasesdatabases

database-performance

Database access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins. Works with EF Core and Dapper.

Aaronontheweb
maintainer
Aaronontheweb
Updated 2/5/2026
Stars
761
Forks
72
quick start

Installation and usage

Database access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins. Works with EF Core and Dapper.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use database-performance