|
Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin. |
Advertisement | |
|
|
Learn how to remove ads |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Serious Flaw in GAB
I have been using
GAB
for a few years now and have over 100 advertisers in my
GAB
setup and run 2 different ad locations (both horizontal banners) on my site. I have noticed over time that
GAB
will slow down the site at times, so finally I got my developer to look into it and look into the server logs because recently my site would almost stop functioning for a couple of minutes at a time.
it turns out the something in the Cron job for GAB statistics that was taking place at 20 minutes past the hour was running HUGE queries, for example the log shows over 6.5 MILLION rows examined in one of the queries that was taking a really long time and slowing down the site. I don't know exactly what is wrong with GAB and its queries but it would appear that over time GAB is going to slow your site down more and more as the statistics get out of hand. |
#2
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
GAB and GAB Stats for vB4 have been released | Morgan | Announcements | 0 | 05-19-2010 01:58 AM |
GAB 2.x >>> GAB beta versions | Tigratrus | Geek Advertising Banner System | 3 | 04-01-2008 05:59 AM |
TRying to download GAB, but it is downloading it as GAB read on | LincolnForums | Geek Advertising Banner System | 5 | 06-07-2006 06:29 PM |