Re: Search query optimization

2008-06-30 Thread Chris Hostetter
: If I know that condition C will eliminate more results than either A or B, : does specifying the query as: "C AND A AND B" make it any faster (than the : original "A AND B AND C")? Nope. Lucene takes care of that for you. -Hoss

Re: Search query optimization

2008-06-30 Thread wojtekpia
If I know that condition C will eliminate more results than either A or B, does specifying the query as: "C AND A AND B" make it any faster (than the original "A AND B AND C")? -- View this message in context: http://www.nabble.com/Search-query-optimization-tp17544667p18205504.html Sent from the

RE: Search query optimization

2008-06-17 Thread Chris Hostetter
: test. If most of requests return the same set of data, cache will : improve the query performance. But in our usage, almost all requests : have different data set to return. The cache hit ratio is very low. that's hwy i suggested moving clauses that are likely to be common (ie: your "within the

RE: Search query optimization

2008-06-17 Thread Yongjun Rong
ng -Original Message- From: Chris Hostetter [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 2:32 PM To: solr-user@lucene.apache.org Subject: RE: Search query optimization :Thanks for your suggestions. I did try the [NOW/DAY-7DAYS TO : NOW/DAY], but it is not better. And I tried [NOW/DA

RE: Search query optimization

2008-06-17 Thread Chris Hostetter
:Thanks for your suggestions. I did try the [NOW/DAY-7DAYS TO : NOW/DAY], but it is not better. And I tried [NOW/DAY-7DAYS TO : NOW/DAY+1DAY], I got some exception as below: : org.apache.solr.core.SolrException: Query parsing error: Cannot parse : 'account:1 AND recordeddate_dt:[NOW/DAYS-7DAYS

RE: Search query optimization

2008-06-17 Thread Yongjun Rong
om: Chris Hostetter [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 1:55 PM To: solr-user@lucene.apache.org Subject: Re: Search query optimization : Probably because the [NOW/DAYS-7DAYS+TO+NOW] part gets rewritten as lots : of OR clauses. I think that you'll see that if you add &

RE: Search query optimization

2008-06-17 Thread Yongjun Rong
DAY. Yongjun Rong -Original Message- From: Otis Gospodnetic [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 1:32 PM To: solr-user@lucene.apache.org Subject: Re: Search query optimization Hi, This is what I was talking about: recordeddate_dt:[2008-06-16T00:00:00.000Z TO 2008

Re: Search query optimization

2008-06-17 Thread Chris Hostetter
: Probably because the [NOW/DAYS-7DAYS+TO+NOW] part gets rewritten as lots : of OR clauses. I think that you'll see that if you add &debugQuery=true : to the URL. Make sure your recorded_date_dt is not too granular (e.g. : if you don't need minutes, round the values to hours. If you don't nee

Re: Search query optimization

2008-06-17 Thread Otis Gospodnetic
s, no minutes, no hours...) Otis -- Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch - Original Message > From: Yongjun Rong <[EMAIL PROTECTED]> > To: solr-user@lucene.apache.org > Sent: Tuesday, June 17, 2008 1:09:19 PM > Subject: RE: Search query optimizatio

RE: Search query optimization

2008-06-17 Thread Yongjun Rong
-16T00:00:00.000-2008-06-17T17:07:57.420]), product of: 1.0 = boost 0.09190578 = queryNorm -Original Message- From: Otis Gospodnetic [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 12:43 PM To: solr-user@lucene.apache.org Subject: Re: Search query optimization Hi

Re: Search query optimization

2008-06-17 Thread Otis Gospodnetic
you don't need hours, round the values to days). Otis -- Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch - Original Message > From: Yongjun Rong <[EMAIL PROTECTED]> > To: solr-user@lucene.apache.org > Sent: Tuesday, June 17, 2008 11:56:06 AM > Subject:

RE: Search query optimization

2008-06-17 Thread Yongjun Rong
Can anyone give me some explaination why this happens if we have the query optimization? Thank you very much. Yongjun Rong -Original Message- From: Walter Underwood [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2008 4:57 PM To: solr-user@lucene.apache.org Subject: Re: Search query

Re: Search query optimization

2008-05-29 Thread Walter Underwood
C&q=A AND B AND C)? Do you > think the order of conditions (A,B,C) in a query will affect the > performance of the query? > Thank you very much. > Yongjun > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yonik >

RE: Search query optimization

2008-05-29 Thread Yongjun Rong
PROTECTED] On Behalf Of Yonik Seeley Sent: Thursday, May 29, 2008 4:12 PM To: solr-user@lucene.apache.org Subject: Re: Search query optimization On Thu, May 29, 2008 at 4:05 PM, Yongjun Rong <[EMAIL PROTECTED]> wrote: > I have a question about how the lucene query parser. For example, I &g

Re: Search query optimization

2008-05-29 Thread Yonik Seeley
On Thu, May 29, 2008 at 4:05 PM, Yongjun Rong <[EMAIL PROTECTED]> wrote: > I have a question about how the lucene query parser. For example, I > have query "A AND B AND C". Will lucene extract all documents satisfy > condition A in memory and then filter it with condition B and C? No, Lucene will