Should I store only the user's session id along with the data in a table, or should I store the user's session id in a table and access an array of data from the user's session id?and why?What is more efficient? I will not be generating any reports.
Where should I store my user session data?
web applications;web
A few comments either directly about or around your question:Whatever you do encapsulate the code so you can change it later.Use whatever is built in to your framework if at all possible.Generally leaving session data weakly typed (in an array or dictionary) isn't as desirable as making it strongly typed, IMHO.  At the very least it discourages people from throwing everything in there without thinking about it.  If you have strongly typed session data that might lead you to your table design based on the way you are mapping all your other objects to tables.  (Obviously, most frameworks give you weakly typed data, but you could always just store one thing there which gets you to your own application specific session object).