You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by naga sharathrayapati <sh...@gmail.com> on 2015/08/25 00:33:23 UTC

Performance improvements

In order to improve the query time of nested faceting query (json facet
api), have used 'docValues' in the schema,optimized index and increased
cache sizes(no evictions)

I still cannot be bring the query time to less than 1 sec.

is there anything that i can do that can improve the performance?

Re: Performance improvements

Posted by naga sharathrayapati <sh...@gmail.com>.
yes, re-indexed after changing the schema


select?q=*:*&wt=json&debugQuery=true&indent=true&rows=0&fq=date%3A%5B2013-08-17T00%3A00%3A00Z+TO+2015-08-17T00%3A00%3A00Z%5D&json.facet={facet1:{range:{end:'NOW/DAY',facet:{namefacet:{terms:{facet:{facet2:{terms:{facet:{sum:"sum(amount)"},field:city,mincount:1}}},field:name,mincount:1}}},start:'NOW-2YEARS/DAY',field:date,gap:'%2B1DAYS'}}}

On Mon, Aug 24, 2015 at 6:50 PM, Yonik Seeley <ys...@gmail.com> wrote:

> On Mon, Aug 24, 2015 at 6:33 PM, naga sharathrayapati
> <sh...@gmail.com> wrote:
> > In order to improve the query time of nested faceting query (json facet
> > api), have used 'docValues' in the schema,optimized index and increased
> > cache sizes(no evictions)
> >
> > I still cannot be bring the query time to less than 1 sec.
> >
> > is there anything that i can do that can improve the performance?
>
> What does the json facet request look like?
>
> If you haven't already, you could try 5.3 as well... it could help if
> you're calculating any facet functions that you aren't sorting by.
>
> http://yonik.com/download/
>
> -Yonik
>

Re: Performance improvements

Posted by Yonik Seeley <ys...@gmail.com>.
On Mon, Aug 24, 2015 at 6:33 PM, naga sharathrayapati
<sh...@gmail.com> wrote:
> In order to improve the query time of nested faceting query (json facet
> api), have used 'docValues' in the schema,optimized index and increased
> cache sizes(no evictions)
>
> I still cannot be bring the query time to less than 1 sec.
>
> is there anything that i can do that can improve the performance?

What does the json facet request look like?

If you haven't already, you could try 5.3 as well... it could help if
you're calculating any facet functions that you aren't sorting by.

http://yonik.com/download/

-Yonik

Re: Performance improvements

Posted by Shawn Heisey <ap...@elyograg.org>.
On 8/24/2015 4:33 PM, naga sharathrayapati wrote:
> In order to improve the query time of nested faceting query (json facet
> api), have used 'docValues' in the schema,optimized index and increased
> cache sizes(no evictions)
>
> I still cannot be bring the query time to less than 1 sec.
>
> is there anything that i can do that can improve the performance?

Without specific information about your setup, I can only offer this:

https://wiki.apache.org/solr/SolrPerformanceProblems

Did you completely reindex after you changed your schema to add
docValues?  I would not expect optimizing the index to be enough.

https://wiki.apache.org/solr/HowToReindex

Other messages on the list from you say that you're running version
5.2.1.  You're probably good on garbage collection tuning, unless you
have changed how Solr is started.

Thanks,
Shawn