Return-Path: Delivered-To: apmail-lucene-java-user-archive@www.apache.org Received: (qmail 65694 invoked from network); 12 Mar 2007 20:46:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Mar 2007 20:46:15 -0000 Received: (qmail 93436 invoked by uid 500); 12 Mar 2007 20:46:17 -0000 Delivered-To: apmail-lucene-java-user-archive@lucene.apache.org Received: (qmail 93402 invoked by uid 500); 12 Mar 2007 20:46:17 -0000 Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: java-user@lucene.apache.org Delivered-To: mailing list java-user@lucene.apache.org Received: (qmail 93391 invoked by uid 99); 12 Mar 2007 20:46:17 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Mar 2007 13:46:17 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [169.229.70.167] (HELO rescomp.berkeley.edu) (169.229.70.167) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Mar 2007 13:46:06 -0700 Received: by rescomp.berkeley.edu (Postfix, from userid 1007) id DFCDD5B763; Mon, 12 Mar 2007 13:45:45 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by rescomp.berkeley.edu (Postfix) with ESMTP id DA2767F403 for ; Mon, 12 Mar 2007 13:45:45 -0700 (PDT) Date: Mon, 12 Mar 2007 13:45:45 -0700 (PDT) From: Chris Hostetter To: java-user@lucene.apache.org Subject: Re: date range querys In-Reply-To: <359a92830703110920v5ebb4dfdvb3f40b9b76a01244@mail.gmail.com> Message-ID: References: <200703111702.27987.tkl@laposte.net> <359a92830703110920v5ebb4dfdvb3f40b9b76a01244@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Checked: Checked by ClamAV on apache.org : I suspect that if you stored your dates (use DateTools) as strings : with a resolution of a day you'd get much faster queries, assuming : that this is fine enough for your app. ...especialy if you use ConstanScoreRangeQUery ... if you find that isn't fast enough, having the various granularities *may* help improve performance, but only if they are stored in seperate fields (so the when you query only at year granularity the termEnum doesn't have to iterate over all the terms at finer granularity) I've never tried this myself ... 99.99% of hte time i'm using Solr, storing things with millisecond resolution, and trusting Solr's caching to take care of makingthings fast enough for me (searching at day/hour granularity 98% of the time makes that caching very effective) -Hoss --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org For additional commands, e-mail: java-user-help@lucene.apache.org