Log all the searched query and process the log offline to find number of searches and frequency.
On 6 August 2015 at 22:27, Upayavira <[email protected]> wrote: > > > On Thu, Aug 6, 2015, at 05:48 PM, Paul Jungwirth wrote: > > > Thank you for your reply. I thought of this. My site has about 600,000 > > > active users. I'm no SQL expert but wouldn't that put an incredible > strain > > > on the server? > > > > Hi Ryan, > > > > The real question is how many searches per minute are happening, and > > whether adding that many INSERTs will be a problem. If it is, you could > > instead increment the counts in a faster-to-update store like Redis, and > > then every 10 minutes (or whatever) flush that to your database. Note > > none of this is really depends on Solr or Lucene. :-) > > Or if the number of searches done is smaller, you have a perfectly good > datastore in Solr/Lucene. You can find the most used searches using > faceting and other familiar methods. > > Upayavira >
