Maybe create a snippet of code in the page of the video information that if the page was accessed from search results it will increment a counter within a database (sqlite, mysql, etc). You can then update solr every so often (daily, hourly, twice a day, etc) and include the hits. This would then allow you to run a query on solr similar to "q=video&sort=hits desc&rows=10" that would return the top 10 results.
Depending on the amount of videos and the data you are indexing I think it would be a quick update. If it is a lot of information you could even setup a secondary solr instance that would only contain information to build such queries. For example if you were only returning the hits and the name+id (to build link) the schema would be simple and updates should be quick. Maybe even quick enough to update as the video is accessed. Someone more familiar with solr would know how intense that would be on resources better than I would. The first choice would probably give you more options since you can include category breakdowns or other breakdowns within your query. . Pete On 7/6/07, Walter Underwood <[EMAIL PROTECTED]> wrote:
Solr doesn't have a record of what documents were accessed. The document cache shows which documents were in the parts of search result list which were served, but probably not a count of those inclusions. Luckily, this information is trivial to get from HTTP server access logs. Look for documents with a referrer that is the search page. Odd, I'm grepping our logs for that sort of data today. wunder On 7/6/07 6:59 AM, "Karen Loughran" <[EMAIL PROTECTED]> wrote: > > Hi all, > Is there a way through solr to find out about "most commonly accessed" solr > documents ? So for example, my client may wish to list the top 10 most > popular videos, based on previous accesses to them in the solr server db. > > If there are any solr features to help with this can someone point me to > them ? Had a browse through the user documentation, but can't see anything > obvious ? > > Many thanks > Karen Loughran
