I'm trying to work out what to do with some data I have which is used throughout a users session.
I need to hold up to 200 integers for a customer - not all customers will have 200, some may have none at all.
When I look at what this will consume in session, 1Gb of memory would be enough to support 2m users with full allocation. Even with an extremely busy site, say 1000 simultaneous users, memory would not be stretched.
With this in mind the obvious conclusion is to put the data in session, particularly as the tables data is retrieved from may contain 1m records.
The question I have is - is there anything else i need to consider - any hidden gremlins that I need to watch out for, or is it as simple as that?
View Complete Post