>>I have a spec on a project that has me counting page views in order to >>generate a 'most popular' list of the 10 most commonly >>clicked on links. >> >>Has anybody done anything like this? >> >>Initially I was thinking of a db counter that incremented a >>field in my db >>as people viewed the page. Is there a better way to do this?
that is the right approach, you need the info in the db for the resulting query. if your site is high load, you could cache the value in an application var ( do lock! ) and update the db less often to avoid so many database updates z ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm