Return-Path: Delivered-To: apmail-lucene-general-archive@www.apache.org Received: (qmail 63945 invoked from network); 11 Jun 2009 20:27:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Jun 2009 20:27:46 -0000 Received: (qmail 39762 invoked by uid 500); 11 Jun 2009 20:27:57 -0000 Delivered-To: apmail-lucene-general-archive@lucene.apache.org Received: (qmail 39726 invoked by uid 500); 11 Jun 2009 20:27:57 -0000 Mailing-List: contact general-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: general@lucene.apache.org Delivered-To: mailing list general@lucene.apache.org Received: (qmail 39716 invoked by uid 99); 11 Jun 2009 20:27:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Jun 2009 20:27:57 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ted.dunning@gmail.com designates 74.125.46.31 as permitted sender) Received: from [74.125.46.31] (HELO yw-out-2324.google.com) (74.125.46.31) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Jun 2009 20:27:45 +0000 Received: by yw-out-2324.google.com with SMTP id 2so972149ywt.5 for ; Thu, 11 Jun 2009 13:27:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=Q0wY+cK83v8WLgPs97mtMmp8Oiq2MQkMVL9y3cVvzDw=; b=mn7C4LrR/gOrOehpo6kMJ78CiMGspoTJi83KrFmdgx+y4rZvaGd/Esm19F/g+GJfQH DCvKRUHE1t+GEngDKpZManXH3q8s0sd/62vbpkLhJXlNID+e1hRYecx8W6iw+i6LfwW5 hFnr2PZrCVnjEsp3O7Qs3PDDGLEDQT4YMe51w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=iQoDCjjePuQb0lSFGPPHl/b2PXDFpEedbWyIcGUmDAbyJrf79YD48RsSR8X6pK4opk G/1W/E3MqMvg0qpaPsPuQjckGqWNJVebLzQ1WWCoA0WkkoVhYS2K6z0Jhh09CR/Pn1A3 ODcs4PpvilQQiy5J6QPMXMddEASlveM6SdLKU= MIME-Version: 1.0 Received: by 10.151.113.19 with SMTP id q19mr5797826ybm.324.1244752044739; Thu, 11 Jun 2009 13:27:24 -0700 (PDT) In-Reply-To: <23987086.post@talk.nabble.com> References: <23987086.post@talk.nabble.com> From: Ted Dunning Date: Thu, 11 Jun 2009 13:27:04 -0700 Message-ID: Subject: Re: Performance: Field.Store.YES vs. Field.Store.NO + DB To: general@lucene.apache.org Content-Type: multipart/alternative; boundary=001517573df275cf2b046c186b8b X-Virus-Checked: Checked by ClamAV on apache.org --001517573df275cf2b046c186b8b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit A traditional database is not normally used for this. Look at something like Voldemort or Hbaseor even memcache instead. Also, you database is moderately large, but not massively so. With a decent sharding system like Katta, you should be able to store the text in your index and still get good retrieval performance. On Thu, Jun 11, 2009 at 12:00 PM, ywlee522 wrote: > I have read in several places that actual values (text) can be stored in > DB, > while lucene only manages index with Field.Store.NO > -- Ted Dunning, CTO DeepDyve --001517573df275cf2b046c186b8b--