# Database Performance

> Database access patterns for 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. Use when designing data access layers, optimizing slow database queries, choosing between EF Core and Dapper, or avoiding common performance pitfalls.

- Page: https://ss33.ai/skills/wshaddix/database-performance-5280803115
- Publisher: wshaddix
- Category: [Data & Analytics](https://ss33.ai/skills/category/data-and-analytics-m1r3i9) › [Databases & SQL](https://ss33.ai/skills/category/data-and-analytics-m1r3i9/databases-and-sql-f7srkv)
- Source: https://github.com/wshaddix/dotnet-skills/blob/09da68dc1f3c06f3bde05f49a6301c75478ab123/skills/database-performance/SKILL.md

## Skill

This skill's licence does not allow redistribution, so the store does not serve its text. Get it from the author: https://github.com/wshaddix/dotnet-skills/blob/09da68dc1f3c06f3bde05f49a6301c75478ab123/skills/database-performance/SKILL.md