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
