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:194711 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
