Re: Session vars stored in database?
What Barney said is dead-on. I am a total zero on clusters, but isn't there a way -- outside of CF -- to handle sessions so they remain sticky despite the application? i.e. an external application of some sort. Would that be db-related? Systems guys at that level usually aren't so ignorant so I'm wondering if he is taking something non-CF into account. And even there was such a thing in play, I can't see how proper locking practices would be mitigated in any meaningful way. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| 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:183272 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
Re: Session vars stored in database?
He could be talking about a custom session management scheme. I have used rsession (http://vfive.com/rsession/index.html)in previous (CF5) projects in order to avoid having to lock session vars and to support non-sticky sessions in clusters. -Phil What Barney said is dead-on. I am a total zero on clusters, but isn't there a way -- outside of CF -- to handle sessions so they remain sticky despite the application? i.e. an external application of some sort. Would that be db-related? Systems guys at that level usually aren't so ignorant so I'm wondering if he is taking something non-CF into account. And even there was such a thing in play, I can't see how proper locking practices would be mitigated in any meaningful way. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183282 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
Re: Session vars stored in database?
You can do sticky sessions in a cluster, but that means that a given session always ends up on the same server, not than the session data is shared across the cluster to whatever machine needs it. That's done with the load balancing hardware/software. Still RAM-only session vars, becuase they're never needed on multiple servers in the cluster. If you're using J2EE sessions, you can do session replication across the cluster as well, but that's still RAM-only. The servers just broadcast the data direct to the other servers, not going through an external store (a DB), as I understand it. Never seen it in action, so I don't know for sure. cheers, barneyb On Wed, 3 Nov 2004 08:36:37 -0800, Matt Robertson [EMAIL PROTECTED] wrote: What Barney said is dead-on. I am a total zero on clusters, but isn't there a way -- outside of CF -- to handle sessions so they remain sticky despite the application? i.e. an external application of some sort. Would that be db-related? Systems guys at that level usually aren't so ignorant so I'm wondering if he is taking something non-CF into account. And even there was such a thing in play, I can't see how proper locking practices would be mitigated in any meaningful way. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com -- 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=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183284 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
Session vars stored in database?
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
Re: Session vars stored in database?
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