Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-31 Thread david3s
Chris, This is really good stuff, I said stuff not really thinking/knowing about the index inner-workings. I was thinking if I could use copyField, as in my previous example: field name=body type=text / field name=has_body type=boolean / copyField source=body dest=has_body/ But I guess I

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-27 Thread Chris Hostetter
: Ok, I'll take your suggestion, but I would still be really happy if the : wildcard searches behaved a little more intelligent (body:* not looking for : everything in the body). More like when you do q=*:* it doesn't really : search for everything in every field. If you can suggest an algorithm

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-23 Thread Erick Erickson
Maybe you can spoof this by using an fq clause instead? as fq=body:*? The first one will be slow, but after that it'll use the filterCache. FWIW, Erick On Wed, Aug 22, 2012 at 4:51 PM, david3s davi...@hotmail.com wrote: Ok, I'll take your suggestion, but I would still be really happy if the

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-23 Thread lboutros
You could add a default value in your field via the schema : field ... default=mynuvalue/ and then your query could be : -body:mynuvalue but I prefer the Chris's solution which is what I usually do. Ludovic. - Jouve France. -- View this message in context:

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-22 Thread david3s
Hello Chris, thanks a lot for your reply. But is there an alternative solution? Because I see adding has_body as data duplication. Imagine in that in a Relational DB you had to create extra columns because you can't do something like where body is not null If there's no other alternative I'll

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-22 Thread Michael Della Bitta
The name of the game for performance and functionality in Solr quite often *denormalization*, which might run against your RDBMS instincts, but once you embrace it, you'll find that things go a lot more smoothly. Michael Della Bitta Appinions | 18

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-22 Thread Jack Krupansky
To: solr-user@lucene.apache.org Subject: Re: Solr 3.6.1: query performance is slow when asterisk is in the query Hello Chris, thanks a lot for your reply. But is there an alternative solution? Because I see adding has_body as data duplication. Imagine in that in a Relational DB you had to create

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-22 Thread david3s
Jack, sorry to forgot to answer you, we tried [* TO *] and the response times are the same as doing plain * -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-3-6-1-query-performance-is-slow-when-asterisk-is-in-the-query-tp4002496p4002708.html Sent from the Solr - User

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-22 Thread david3s
Ok, I'll take your suggestion, but I would still be really happy if the wildcard searches behaved a little more intelligent (body:* not looking for everything in the body). More like when you do q=*:* it doesn't really search for everything in every field. Thanks -- View this message in

Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-21 Thread srinalluri
Our environment is Solr 3.6.1. I have the following fieldType. There is a field called 'body' of this fieldType. When I make a query: q=body:*, it is talking longer than the expected. What are the changes I need to do to this fieldType for better query performance? Some other fieldTypes in our

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-21 Thread Jack Krupansky
. -- Jack Krupansky -Original Message- From: srinalluri Sent: Tuesday, August 21, 2012 4:21 PM To: solr-user@lucene.apache.org Subject: Solr 3.6.1: query performance is slow when asterisk is in the query Our environment is Solr 3.6.1. I have the following fieldType. There is a field

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-21 Thread Chris Hostetter
: Our environment is Solr 3.6.1. I have the following fieldType. There is a : field called 'body' of this fieldType. When I make a query: q=body:*, it is : talking longer than the expected. What are the changes I need to do to this : fieldType for better query performance? Some other fieldTypes

Re: Solr 3.6.1: query performance is slow when asterisk is in the query

2012-08-21 Thread srinalluri
Thanks Jack for your reply. I don't have much documents which have a null field value. I added ReversedWildcardFilterFactory to test the performance improvement only, but that didn't help. What else changes I can do to the fieldType? thanks Srini -- View this message in context: