ASP.NET how to cache variable in header?

Question

ASP.NET

Each time a request is made, a selection is made in the header again, and, accordingly, operations on the page are performed on it.

As an example:

@{
var users = context.Users.Where(x => x.Status != null).ToList();
}

I think with a large amount of data (I have about 300k) and 20+ requests per second, the execution speed on the server will noticeably drop. Is it possible to somehow cache this variable, or do some other trick with it so that it is not loaded once again? I thought about indexing it, but in fact it is always unchanged...

Answer 1

Try something like this.
When the collection changes, call UserStatus.Instance.UserChanged(users);

public class UserStatus{
  public static UserStatus Instance => _instance;
  public IList<User> Users => getUsers(); 
  public void UserChanged( IList<User> users){
///
}
}

Answer 2

https://docs.microsoft.com/en-us/aspnet/core/perfo... . I think it's a more reasonable solution.