23 min read
EF Core Split Queries: The Hidden LIMIT Slowing PostgreSQL
EF Core split queries with SingleOrDefaultAsync hide a LIMIT subquery PostgreSQL can't optimize. One extension method took an endpoint from 5.45s to 155ms.
> topic · 1 article
1 article about PostgreSQL by Ivan Gechev – practical .NET and C# backend development guides.
23 min read
EF Core split queries with SingleOrDefaultAsync hide a LIMIT subquery PostgreSQL can't optimize. One extension method took an endpoint from 5.45s to 155ms.