EF Core 11 makes your split queries faster
8 days ago
- #Query Optimization
- #Performance
- #EF Core
- EF Core 11 improves performance of split queries by pruning unnecessary reference navigations from collection queries.
- In EF Core 10, split queries with multiple reference navigations included extra JOINs and ORDER BY columns in collection queries, causing inefficiencies.
- EF Core 11 removes these unnecessary joins, resulting in faster queries with reduced database work and fewer allocations.
- Benchmarks show a decrease in execution time and memory usage when using split queries in EF Core 11 compared to EF Core 10.