My site gets a large amount of traffic, and I am using fuseads (formerly available from fusetalk, inc....) for my ad server in its "high load" mode. I do not like the fact that ad-related DB usage (primarily for logging impressions and click throughs) are contributing to my page processing time, and I am looking to eliminate or significantly reduce that usage to allow for better performance and scalability. I plan to write an optimized fuseads (formerly available from fusetalk, inc....) java wrapper for my CF site which does the following: 1) Singleton thread-safe instance of it in the application scope 2) Persistent cache of banners, loaded from Fuseads DB, but kept as local objects, reloaded in a separate, non CF thread (i.e. not by cfschedule, but by me spawning a maintenance thread when you use this object) 3) manages click-throughs, impressions, and only does batch updates on the DB when a banner reaches X (say, 1000) impressions. Clickthroughs updated also through this maintenance thread.... The goals for me: 1) No ad-related DB access is in the CF response threads 2) Ad contribution to response time is minimal because always reading from memory 3) DB use is better optimized for a site with alot of hits (since the existing fuseads inserts a row in an impression table every time a banner is displayed, and aggregates it nightly. I'd like to reduce those inserts by a scale of 1000 since the site is getting 600K pageviews a day, so there's no real point of counting banner impressions with such precision) Any suggestions, thoughts, etc? I'm running MX 6.1 with IIS on a 2x933Mhz machine with 1GB RAM, and SQL2K on the same box. Thanks dov -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185785 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
