For read-heavy queries, AsNoTracking() provides massive performance improvements.
var users = await ctx.Users.AsNoTracking().ToListAsync();
It avoids adding entities to the change tracker, improving speed by 30–50%.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
For read-heavy queries, AsNoTracking() provides massive performance improvements.
var users = await ctx.Users.AsNoTracking().ToListAsync();
It avoids adding entities to the change tracker, improving speed by 30–50%.