I recently wrote a banner ad server that serves up to four, sometimes five ads per page. I can't really say how well it will scale when our page views approach a million per day, but I don't think there's much of a performance hit for recording impressions.
I keep daily performance records for ad/creative/date. When I record the impression I do a two-query process of check if record exists, if not, do an insert, else do an update. But the key is that I don't check the number of impressions every time I pull an ad. I have a scheduled CF template that runs once every two hours and checks to see if ads have run their course, either having exceeded their number of impressions or their end date, then marks them inactive. Running an ad for just a couple extra hundred, or even a couple thousand impressions is the only compromise and the advertiser seldom minds. ----- Original Message ----- From: "Katz, Dov B (IT)" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, February 15, 2005 6:19 AM Subject: RE: Simple Banner Ad System > Word of warning here. I have been using fuseads for 4 years on > www.onlysimchas.com -- DB inserts/updates to record banner impressions > *does not scale* > > Updating a DB on every page view, *especially* when you're constantly > reading from the same data to display things will eventually lead to a > degradation of site performance which could become overwhelming. > > Fuseads gets around this with their "high performance mode" (I don't > think they sell this product any more).. The High performance mode > inserts banner views/impressions into a separate table, and aggregates > the count back into the main banner table every night. This keeps the > read/write conflicts to a minimum. > > Inserts every page view, however are pretty ugly as well. Might be good > for small sites, but as my site grew to get 700k page views a day (Each > with multiple banners on the page) it totally hosed me out. > > Here are some of the fixes/extremes I went to to avoid banner serving > impacting performance: > > 1) Cache the banner query for 4-6 hours at a time > 2) Store struct in app scope of banners and counts, increment that on > every view, and CFLOG to the datbase every 1000 views > 3) I wrote a log parser I run once weekly to update views in the DB > > This reduced my # if DB inserts per day from 3-5 million to 0 :) > > Just some of my scars, thought I'd share > > -dov > > > -----Original Message----- > From: Jason Bartholme [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 15, 2005 6:58 AM > To: CF-Talk > Subject: Re: Simple Banner Ad System > > Hi Dwayne, > > Give this tut a look: http://www.tacktech.com/display.cfm?ttid=97 We > run about 7 different ad managers that I based off of this code. > >> I'm looking for a banner ad system to intergrate into a CMS that I've >> built. >> >> From a administratative perspective, I don't mind using a seperate >> admin panel. However, on the front end I would like to call the ads >> via a custom tag, cffunctioin, or a cf component. >> >> Tracking click throughs is a plus, but not necessary, Multiple banners > >> for each sponsor is a plus but not neccessary, Assigning some sort of >> random frequency weight or priority is a plus but not a requirements >> and managing campaign duration is a plus but not a requirement. >> >> I recall seeing this type of request pass through the list but >> unfortuanately I did not save the thread. >> >> Dwayne D. Cole >> www.fluxflow.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
