Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=x+15aXeewwXyN87QvXB0DEzEWuDk/n6aHLF0vkWOb4FaY0ZbbP4jZzBdR8PM3BM1/gQdb5359QjWSwZvhUWfxKw4BSSiCAlKthJELBROixHeMAzj37fu6RjCu0f4ggDy4Aai/XmqX500T1c9QP8Bhx8+REBCHGcvD8JT9ET1nlM=
  ;
Message-ID: <20051124225441.119.qmail@web36315.mail.mud.yahoo.com>
Date: Thu, 24 Nov 2005 14:54:41 -0800 (PST)
From: Victor Lee <victor_emailbox@yahoo.com>
Subject: Re: Is It a Good Idea to Save Frequently Search Results in Database
 to Make It Faster?
To: java-user@lucene.apache.org
In-Reply-To: <20051124225042.70176.qmail@web36311.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1632656566-1132872881=:98377"
Content-Transfer-Encoding: 8bit

--0-1632656566-1132872881=:98377
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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 
--0-1632656566-1132872881=:98377--