lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <e...@ehatchersolutions.com>
Subject Re: Is It a Good Idea to Save Frequently Search Results in Database to Make It Faster?
Date Fri, 25 Nov 2005 01:33:50 GMT
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 <victor_emailbox@yahoo.com> 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: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org


Mime
View raw message