Tracking thousands of entities slows everything.
✅ Fix
context.ChangeTracker.QueryTrackingBehavior = NoTracking;
Or per query:
.AsNoTracking()
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Tracking thousands of entities slows everything.
context.ChangeTracker.QueryTrackingBehavior = NoTracking;
Or per query:
.AsNoTracking()