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. :-)
Good luck!
Paul
