I want to show the top 10 most viewed records on a per user basis. It also needs to be time biased where records viewed long ago carry little weight. The application consists of a user logging onto a private site and viewing real estate opportunities, and having their individual "popular" records displayed when they initially log on.
One thought was to associate a "rank" for each user/record pair. Every time the record is viewed, the current rank value is decreased based on the age of the rank value, but then increased because it was just viewed.
Any advise would be much appreciated.