You could also add a bodySize numeric (trie) field, which you can check for 0 for empty/missing bodies.

And don't forget to check and see whether the "[* TO *]" range query might be faster.

-- Jack Krupansky

-----Original Message----- From: david3s
Sent: Wednesday, August 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 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 have to go with your suggestion that I
greatly appreciate.



--
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-tp4002496p4002698.html Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to