I got into a debate with a system guy today who told me they were storing their session vars in the SQL database. I insisted he'd got his terminology wrong and in fact it was client vars he's storing not session vars.
He was adamant. No, it's definitely session vars stored there. Not only that, he said that they had a lot of sessions (for example 50,000 sessions last month) and if they locked them all every time they accessed them, the server would crawl to a halt. He left me in no doubt ... i was NOT to lock session variables, either reading them or writing them, and that the were stored in the database. Do you he's got it right? The environment is multiple load-sharing Win2000 servers, CF5. My understanding of it all was that you ALWAYs locked session vars. If you're reading them, use a readonly lock, if you're changing them, use an exclusive lock. And that session vars are always stored in server RAM. Not so? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183231 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
