Most frequent searched query string - Ferret

Hi,

I need to calculate most frequent searches on a particular model. I am using ferret for searching in full text mode.

For eg: Search on hospital names. I have a form which allows user to enter a search query, and underneath ferret does the search and provides the results.

Now, I would like to show the user, some previous search related data like Most frequent/popular search data.How can i do that? Does ferret have any inbuilt mechanism for this or do I have to build my own. Please suggest on ideas as well.

Regards, SG

Hi Sandeep,

Hi,

I need to calculate most frequent searches on a particular model. I am using ferret for searching in full text mode.

For eg: Search on hospital names. I have a form which allows user to enter a search query, and underneath ferret does the search and provides the results.

Now, I would like to show the user, some previous search related data like Most frequent/popular search data.How can i do that? Does ferret have any inbuilt mechanism for this or do I have to build my own. Please suggest on ideas as well.

If "most frequently searches" are not dependent on user who is searching, I mean: these are not user's most frequenlty searches, then why don't you go with simple integer field in your model that gets increased every time record gets listed in search results?

I was only hoping Ferret will have some mechanism to keep track of searched keywords, based on which it can specify what is the most searched keyword.

If i have to do manually , i will have to modify multiple rows that were found in database for every search. Is this the normal way of doing it?

Also, since i do paginate of the results, i end up updating only a few rows though all other rows also figure in search results.

Regards, SG

You could model your search as it own resource. Instead of hacking up your existing tables, you would just save the search terms in the search model and use the index view to list previous searches and the show view to run them again.

Chris B http://www.randomutterings.com