Optimizing read-heavy Entity Framework Core queries for maximum QPS:

1. .AsNoTracking(): Disables EF Core Change Tracker snapshot allocations, saving 50% CPU and memory on read operations.
2. EF.CompileAsyncQuery: Pre-compiles the LINQ expression tree into a parameterized SQL delegate once at startup, eliminating query compilation overhead on every HTTP request:

private static readonly Func<AppDbContext, int, Task<User?>> GetUserByIdQuery =
    EF.CompileAsyncQuery((AppDbContext ctx, int id) => 
        ctx.Users.AsNoTracking().FirstOrDefault(u => u.Id == id));

// Execution: 4x faster execution!
var user = await GetUserByIdQuery(dbContext, userId);

Compiled queries are fantastic for high-frequency microservice lookups.

Combined with .AsNoTracking(), EF Core performance gets remarkably close to raw Dapper speeds.