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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223669 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

