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: But I guess I would have had to write a custom processor and define a specific field type. I guess a more elegant

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 algorith

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 : 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: http://lucene.472066.n3.nabble.com/Solr-3-6-1-que

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 wrote: > Ok, I'll take your suggestion, but I would still be really happy if the > wildcard searche

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 conte

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 Jack Krupansky
22, 2012 12:37 PM 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

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 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-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: http://luce

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 in

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

2012-08-21 Thread Jack Krupansky
You could try a "[* TO *]" range query. It will also match all documents which have a non-null field value. So: q=body:[* TO *] Actually, I see that you have reverse wildcard enabled. Try removing that. "*" would normally map to PrefixQuery, which is normally more efficient than a WildcardQue