View Single Post
  #1  
Old 03-09-2009, 07:07 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

The compress_stats function keeps tracks of the statistics data. If you keep tracking for all time, then the related database table is going to continue to grow so the next GROUP BY query to get the stat totals is going to be bigger than the last. While it is possible to total on each display of an ad, it is not desirable as it adds to the front-end weight, so totaling gets done in a cron. You could set the cron to run more frequently via the ACP -> Scheduled Tasks -> Scheduled Task Manager -> Edit GAB Cron, maybe three or four times a day instead of once, or you can use the ACP -> GAB -> Manage -> 'Deactivate AND Compress (the cron job)' to manually do several times a day what the cron does once a day. If you want to restart your statistics, then you can run the following queries to be rid of all the current stats:
Code:
# warning: deletes all statistics data !!!!
DROP TABLE IF EXISTS GAB_temp_stats;
TRUNCATE TABLE GAB_stats;
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote