He's all kinds of screwed up in the head. Session variables are strictly in-memory, and number of sessions has no impact on locking performance. The only thing that will affect locking performance is number of concurrent requests within a single session.
Locking session variables is required on CF5 (as it is for the other shared scopes), both for race conditions and for avoiding memory corruption. On CFMX, locking is only needed for race conditions, thanks to Java's strict control over memory access. Bottom line, you're 100% right, and your systems guy is 100% wrong. cheers, barneyb On Wed, 3 Nov 2004 17:34:59 +1100, Mike Kear <[EMAIL PROTECTED]> wrote: > 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 > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183232 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
