> I just decided to take a look at our CFCLIENTS database and was alarmed at > the rowcounts: > > CDATA > 30825485 rows > > CGLOBAL > 34472178 rows > > Does this seem ridiculously high?
Yes, that's quite high. Like others have said, the purge functionality in CF both has a very long default and doesn't work very well anyway. I recommend you create a database task to do this more frequently. > We do have to restart CF from time to time due to issues with lots of file > manipulations/image creation etc. > So would this mean that the session data becomes orphaned from real sessions? First, it's important to differentiate Session from Client. They're two different things. So, I'll assume you're not actually using the CF Session scope, just the Client scope. Second, if my assumption above is correct, restarting CF will have no effect on users being orphaned from their Client data, as you're not storing that in memory, but rather in the database. Users will have access to the Client data as long as their cookies are intact. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
