is there a global config setting to turn stats off ? i looked in the admin section, thru the mailing list and so on but cant find the magic switch.
I came across the same dilemma as Geoff, but rather than turn stats off and remove the graphs from the myFarcry page, I wrote a simple script to purge any stats (and search stats) older than 31 days (45 days on one server).
This gives the marketing department a quick idea on how their recent marketing campaigns are going. When they want to view anything older than that (usually to get a broader perspective on things) then they rely on the web log analyzers.
Doing this allows FarCry users to keep all of the "stats" features but with only a month's worth of data.
What I should probably do is write a dmCron that allows users to schedule stats truncation and allow the admin to set it to however many days they want. I woluld likely make it an option to choose which stats table you want to truncate (stats and/or searchStats) by prodiding them as checkboxes.
Would anyone be interested in this?
-Jeff C.
P.S. Don't forget to do database maintenance. Example: I use MSSQL. Because I do daily backups of the database I make sure to truncate the logs just after the backup is complete. In my experience with Farcry websites this saves me about 30% of the space used by the database and increases performance considerably. Like indexing your tables, database maintenance is important. If you are not familiar with these features it is a good idea to talk with a DBA if you have access to one.
--- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
