EF Core N+1 Query Problem: How to Detect, Measure, and Fix
If your EF Core application works perfectly with a small dataset but suddenly slows down as the amount of data grows, don’t immediately blame your API, server, or database hardware. The problem may be much simpler: your application is making too many database queries. One of the most common causes is the N+1 query problem…