Slow query response from SOLR 5.4.1

[Abhijit Pawar <aa...@gmail.com>]

Hello,

I am seeing a performance issue in querying in one of the SOLR servers -
instance version 5.4.1.
Total number of documents indexed are 20K plus.
Data returned for this particular query is just as less as 22 documents
however it takes almost 2 minutes to get the results back.

Is there a way to improve on performance of query - in general the query
response time is slow..

I have most of the fields which are stored and indexed both.I can take off
some fields which are just needed to be indexed however those are not many
fields.

Can I do something solrconfig.xml in terms of cache or something else?

Any suggestions?

Thanks!!

Re: Slow query response from SOLR 5.4.1

[Abhijit Pawar <aa...@gmail.com>]

Jason,

Not yet.This issue was on the back burner for a few days....However we
still need to figure out what could be a potential solution to it.
The setup is basic one - with one node / no shards or replicas
2 cores

When I run the query adding debug=timing to raw query parameters it just
hangs in there without a response back.
Today the response is much better though it takes 15-20 seconds however we
would like to speed it up more better.

Any suggestion would be appreciated.Thanks!



On Tue, Aug 11, 2020 at 11:01 AM Jason Gerlowski <ge...@gmail.com>
wrote:

> Hey Abhijit,
>
> The information you provided isn't really enough for anyone else on
> the mailing list to debug the problem.  If you'd like help, please
> provide some more information.
>
> Good places to start would be: what is the query, what does Solr tell
> you when you add a "debug=timing" parameter to your request, what does
> your Solr setup look like (num nodes, shards, replicas, other
> collections/cores, QPS).  It's hard to say upfront what piece of info
> will be the one that helps you get an answer to your question -
> performance problems have a lot of varied causes.  But providing
> _some_ of these things or other related details might help you get the
> answer you're looking for.
>
> Alternately, if you've figured out the issue already post the answer
> on this thread - help anyone with a similar issue in the future.
> Jason
>
> On Tue, Aug 4, 2020 at 4:11 PM Abhijit Pawar <aa...@gmail.com>
> wrote:
> >
> > Hello,
> >
> > I am seeing a performance issue in querying in one of the SOLR servers -
> > instance version 5.4.1.
> > Total number of documents indexed are 20K plus.
> > Data returned for this particular query is just as less as 22 documents
> > however it takes almost 2 minutes to get the results back.
> >
> > Is there a way to improve on performance of query - in general the query
> > response time is slow..
> >
> > I have most of the fields which are stored and indexed both.I can take
> off
> > some fields which are just needed to be indexed however those are not
> many
> > fields.
> >
> > Can I do something solrconfig.xml in terms of cache or something else?
> >
> > Any suggestions?
> >
> > Thanks!!
>

Re: Slow query response from SOLR 5.4.1

[Jason Gerlowski <ge...@gmail.com>]

Hey Abhijit,

The information you provided isn't really enough for anyone else on
the mailing list to debug the problem.  If you'd like help, please
provide some more information.

Good places to start would be: what is the query, what does Solr tell
you when you add a "debug=timing" parameter to your request, what does
your Solr setup look like (num nodes, shards, replicas, other
collections/cores, QPS).  It's hard to say upfront what piece of info
will be the one that helps you get an answer to your question -
performance problems have a lot of varied causes.  But providing
_some_ of these things or other related details might help you get the
answer you're looking for.

Alternately, if you've figured out the issue already post the answer
on this thread - help anyone with a similar issue in the future.
Jason

On Tue, Aug 4, 2020 at 4:11 PM Abhijit Pawar <aa...@gmail.com> wrote:
>
> Hello,
>
> I am seeing a performance issue in querying in one of the SOLR servers -
> instance version 5.4.1.
> Total number of documents indexed are 20K plus.
> Data returned for this particular query is just as less as 22 documents
> however it takes almost 2 minutes to get the results back.
>
> Is there a way to improve on performance of query - in general the query
> response time is slow..
>
> I have most of the fields which are stored and indexed both.I can take off
> some fields which are just needed to be indexed however those are not many
> fields.
>
> Can I do something solrconfig.xml in terms of cache or something else?
>
> Any suggestions?
>
> Thanks!!