New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

【文章推荐】EF Core 代码性能优化建议 #755

Closed

gaufung opened this issue Nov 6, 2024 · 1 comment

Labels

Collaborator

gaufung commented Nov 6, 2024

https://dev.to/antonmartyniuk/how-to-increase-ef-core-performance-for-read-queries-in-net-2fk9

gaufung added the 文章推荐 label

Collaborator Author

gaufung commented Nov 29, 2024

EF Core 查询优化建议：

创建索引
优化查询投影
对于只读查询，使用 AsNoTracking
使用积极加载（Eager Loading)
使用分页查询结果
使用编译查询
使用 SplitQuery 避免迪尔卡乘积爆炸
使用原生 Sql 语句查询
引入缓存

gaufung closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment