How fast are your searches currently? With just a pure
searcher.search(Query) using a basic query type like TermQuery, I
very seriously doubt you'd beat MySQL performance. What kind of
Query are you using for your searches?
Erik
On 24 Nov 2005, at 17:54, Victor Lee wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
