And we run the aggregation process daily or whatever period is deemed appropriate.
The idea is to allow trend analysis over a longer period. The theory being there is no need to hold all the page requests individually if you are reviewing total page requests daily for a month or whatever.
We just don;t have enough resources just now to give this any attention. We're open to suggestions or folks who want to throw a hand in.
-- geoff http://www.daemon.com.au/
Gavin Cooney wrote:
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).
If you still want the data, but find putting it all in one table was a bad idea (performance-wise), you could possibly break it down into smaller tables using the merge table type in mySQL. I'm sure other databases have an equivalent.
http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html
then i can have a smaller table for each month or something like that.
Just a thought.
--- 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/
