The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Advertising Banner System

Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-09-2009, 05:39 PM
KenDude KenDude is offline
Senior Member
 
Join Date: Nov 2006
Posts: 176
GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Exclamation 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.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
GAB and GAB Stats for vB4 have been released Morgan Announcements 0 05-19-2010 02:58 AM
GAB 2.x >>> GAB beta versions Tigratrus Geek Advertising Banner System 3 04-01-2008 06:59 AM
TRying to download GAB, but it is downloading it as GAB read on LincolnForums Geek Advertising Banner System 5 06-07-2006 07:29 PM


All times are GMT. The time now is 06:23 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.