The SQL session provider loads values as you reference them. But once it's loaded during a request, it is cached in memory for the remainder of that request process.
Microsoft are generally quite good at making their things optimal for stuff like this. |