home/categories/sql-databases/comeonoliver-skillshub-skills-aaronontheweb-dotnet-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.

ComeOnOliver
maintainer
ComeOnOliver
更新於 3/23/2026
星標
26
分支
7
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.

安裝
$ install --globalskills.sh
使用

安裝後,您可以透過在終端機執行以下指令來使用此技能:

skills use database-performance