blis102 wrote: > Hello All, > > Im wondering how I could go about implementing a "Most Viewed" feature > on my site. Lets say I have events, articles, and businesses, how > could I implement a "Most Viewed Businesses", "Most Viewed Articles", > "Most Viewed Events", "Most Viewed Content", "Most Viewed Articles > This Week", etc...? Should I build a model for views and make it a > foreign key to each model I want to record views for? Should I make a > middleware? What else could I do? > > Im not really sure what would be best practice in this regard. Im sure > there are a few different ways to implement this, but what is the > simplest and most scalable? Any other ideas or suggestions?
Simplest and scalable aren't often achievable in the same sentence. Unless your site is very low traffic the thing you don't want to do is write to the database every view. That is anti-scalable. For one project in the past a coworker came up with this: write log files to a ramdisk, one line per view(fast + simple). A cron job slurped the files, did unique views logic, other stuff and updated a times_viewed field in the models. Scaling that to more than one machine adds complexity. I'd probably pursue a different solution when/if traffic warranted it. -- Norman J. Harman Jr. 512 912-5939 Technology Solutions Group, Austin American-Statesman ___________________________________________________________________________ You've got fun! Check out Austin360.com for all the entertainment info you need to live it up in the big city! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
