What database application are you using to store the client vars? If you are using MSACCESS, this is likely the problem. We encountered similar issues when using Access..
Mike -----Original Message----- From: Matthew Learn [mailto:[email protected]] Sent: Thursday, March 26, 2009 11:16 AM To: cf-server Subject: Client Variables and Purging... 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. Questions: 1) I was reading some place about having the Database do the purge instead of CF, if I went that route, how can I disable the CF Purge? 2) Most of the servers are set to restart every night (the user base is such that the system is usually only during business hours), does the purge interval go from the last time that Coldfusion restarted? So if I set a purge interval of 23 hours, then the purge would happen 1 hour before the restart, right? 3) The datasource that we use to store the Client Variables is used by other queries in the system. Is this part of the problem? Should the data source used for Client Variables only be used for client variable information? Would creating a dedicated datasource for Client Variables prevent the bottle neck? I have done some Google searching, and there really is not a lot of information about the Client Variables and the purge interval. I am hoping that someone out there has some real life experience with this issue and have a good suggestion. Thank you. -Matthew R. Learn Modotech Inc. [email protected] 410-972-2165 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:6773 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
