Hi Andre, I'm storing plenty of objects in session scope relating to reporting/queries....and I've used a rather primitive method of determining memory requirements....I output a typical session to flatfile and measure the bytes. Then I've got a rough estimate per user session. I think you'll find you can hold a lot more data with ur existing RAM then you thought!
I used to use query caching but I found it was holding recordsets longer than it had to...if they're in session then they'll dissipate when the sessions over either via logout or browser close...but I'll be honest...I wouldn't have moved to the session solution before CFMX but that's really just paranoia on my part... CFMX is cool because you can easily load balance the session data across a cluster just by editing a server buddy list! Hope that helps, Stace -----Original Message----- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 11:48 AM To: CF-Talk Subject: Measuring session scope impact on memory? Hi, I've never read anything about this so this q is for the gurus! Please read completely and thanks for your attention. Let me describe the issue then I'll ask my question. I've pretty much stuck to client vars to avoid ugly locking code. However now, I have a use for them. I need to store dozens of queries in a structure in the session scope. I've got it coded and it works like a charm(Yes its locked) saving lots of time for the database server. The performance savings is dramatic as the queries that were repeatedly generated each time took time away from other tasks. Client vars might not be so good as I"d have to wddx the whole thing back and forth which would be a big chunk of data to and fro from the server. Plus the serialization and deserialization overhead. Cacheing the queries is not good as each user will have different queries. So, to my question. I've estimated this would take a gig of ram per server to store these queries for all of our users. So, (1)is there a way to measure how much memory is being allocated for session vars? (2)When I look at the cf memory, will it go from 60megs to a gig? Anyone tried this and gotten burnt? Thanks. DRE ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
