The Slow Page Walkthrough

1. What is the first step you should take when diagnosing a slow loading page in EF Core?

Add an index to the database Measure where the time goes Optimize the SQL query Rewrite the query with `Include()`

2. What does the N+1 problem refer to in the context of EF Core?

Loading too many records at once Executing many queries unnecessarily Missing a necessary index Skipping projection in a query

3. Which query method should be used to avoid change tracking for read-only lists?

AsQueryable() AsNoTracking() Include() ToList()

4. When should `Include()` be used instead of projections in queries?

When loading related entities is crucial Only using for small datasets Always as a first option When there is no need to reduce data fetching