Sorry, actually I meant all search results, not just frequent results. And there is only one search term per search, it's the stuff that belongs to the search terms change often.
Victor Lee <[EMAIL PROTECTED]> wrote: Hi, I use Lucene to index stuff that are changed very often but don't need to be real-time to searchers. e.g. the search result can be changed couple times per minute, but I only need to show the change every 5 minutes or so. Is it a good idea to save the search result to a database like mysql db, so that searches will load from db directly rather than doing the same search over and over again? Then after 5 minutes, the system will do the actual search again and then save search result to the db for next 3-5 minutes' searches? Will it make the server handle heavy load better? Since most of the access goes into the database server rather than the webserver with java in backend. Of course, there will be more to implement and maintain. Many thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
