It may help if someone can answer this question: How much memory does it really take to store a single session. How much can you store in the single session to know you're safe with this sort of issue? Anyone have any numbers for this sort of thing? Obviously, each application is different, but how much memory space would it take to store a session with 50 variables in it and 20 arrays/structs with say another 50 variables in each. Assume each value is 200 characters or less. Also, what's the overhead on storing objects in sessions? Is everything simple calculated by figuring how many bytes the text is and assume each session takes that much memory or is there some sort of compression or overhead happening to affect the numbers?
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Morgan Leecy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 9:21 AM To: CF-Talk Subject: SESSION or not to SESSION I am developing a dataing site for a friend, and it looks pretty good, and working really well.. I expected to be able to have time to upgrade as time went on and members went up, but my 'friend' has just bought the member list from a another dating site which is closing down, so all of a sudden I am gonna find my site has 2000 active users, and 27000 casual Whoppee Now the site has SQL2000 in the background so I am not concerned about database access, and I am even going to split the database to two independant sections, but my problem is THIS When users login, a whole host of SESSION variables are created, I also use SESSION variables for quite a few functions as I like to use ARRAYS to kweep things neat, and I cant create arrays with CLIENT variables, and I dont like to use COOKIES as they can be blocked. But lets imagine when we go live, all 29000 sign on, all these SESSION variables will exist in the servers memory, and what happens if loads more sign up? Am I worrying unduly? or is there a better way (can session variables be stored in the database itself? Any suggestions welcome Morgan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223673 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54