This line is expensive:
var users = query.ToList();
π§ Why
-
Executes immediately
-
Loads everything into memory
β Better
Stream or filter first:
var users = query.Where(x => x.IsActive);
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
This line is expensive:
var users = query.ToList();
Executes immediately
Loads everything into memory
Stream or filter first:
var users = query.Where(x => x.IsActive);