EF Core 11 makes your split queries faster
Summary
The article explains how EF Core 11 introduces AsSplitQuery to speed up split queries by issuing separate queries for the root and each collection, while also pruning reference navigations from collection queries. It includes examples, discusses trade-offs, and presents benchmark-style results showing lower runtime and allocations with EF Core 11. It also notes caveats and provides resources for deeper exploration.