>I would love for some thoughts on this. I work for a small software >development company, we have a web application deployed at several clients >using Coldfusion. One of the things that we do is in the Client Variables >we use a database storage. Recently I have found that clients were having >system slow down issues every hour, and I think that it is happening because >of the Purge Interval, which was left at the default 1 hour.
We are seeing the same problem. The hourly slowdowns are driving us crazy. We get around 400K unique visitors a month, and client-based cookies were not working well for us (PCI problems amongst other things). Looking into the cookies database (MSSQL), we saw 3m cookies stored. Well, maybe with the visitors+robots*3 that makes sense (but worries me about the scalability of it!). So we changed the cookie age/purge from 90 days to 45 days, and voila - 6m cookies in 10 hrs. Yes, it doubled the size of the database! Beats the heck out of me. Any CF gurus have any ideas/best practices? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6795 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
