Summary
So what have we learned from all of this. First, it is not a good idea to store
STA objects in the Session variables. You might get away with it on a low volume
site, but if you do run into strange problems, be aware that the problem could
be causes by STA objects. And, unfortunately, the most common objects used by
ASP developers use the STA architecture, namely ADO and FileSystemObjects.
Second, if you do use Session variables, be aware of how much information is
actually being stored. Especially if you have a heavily trafficked site, make
sure that you adjust your memory (both physical and virtual) accordingly.
Finally, if you move to a distributed web server environment, the use of Session
variables can decrease performance by not letting the load balancing service
do its thing. Should you ever use Session variables? They are too compelling
(in my opinion) to answer with a flat "NO". However, their simplicity
belies the caution and thought that should go into their use.