Re: Solr Query Explain Plan

2016-02-15 Thread Binoy Dalal
Wild card and fuzzy queries are in general expensive to compute for the simple reason that the number of query combinations that solr has to check against increases. So the lesser amount of combinations solr has to try, the faster it'll be. I believe that this is what you're seeing. Additionally,

Re: Solr Query Explain Plan

2016-02-15 Thread Shahzad Masud
Thanks Binoy, these links helps. Explain or debug log really helped me, and after few experimentation and debugging, I conclude that if we move wild card queries (marked with *) to right; it improves performance. I haven't been able to find a reference in documentation, but does this statement hold

Re: Solr Query Explain Plan

2016-02-14 Thread Binoy Dalal
There is another resource to help analyze your queries: splainer.io As for query tuning, that is a really vast topic and there is no straightforward answer. You'll have to experiment and find the settings that suit you best. Here's a few resources to help you get started: http://wiki.apache.org/lu

Re: Solr Query Explain Plan

2016-02-14 Thread Shahzad Masud
Thank you Binoy. Is there any pointer available to tune similar queries, as it is taking a huge amount of time? Shahzad On Mon, Feb 15, 2016 at 10:18 AM, Binoy Dalal wrote: > Append &debugQuery=true to your query. > It isn't exactly like a SQL execution plan but will give you the details of > h

Re: Solr Query Explain Plan

2016-02-14 Thread Binoy Dalal
Append &debugQuery=true to your query. It isn't exactly like a SQL execution plan but will give you the details of how the query was parsed, scored and how much time was taken by each module used by the request handler. On Mon, 15 Feb 2016, 10:42 Shahzad Masud < shahzad.ma...@northbaysolutions.net