Subject: Query takes more time in Solr 8.5.1 compare to 6.1.0 version


Hi Jason

Thanks for reply.

I have checked jay's query using "terms" query parser and it is really helpful to us. After execute using "terms" query parser it will come within a 500 milliseconds even though grouping is applied.
Jay's Query : https://drive.google.com/file/d/1bavCqwHfJxoKHFzdOEt-mSG8N0fCHE-w/view

Actually I want to apply same things in my query but my field "msg_id" is applied boost.group is also used in my query.
I am also upgrading Solr 8.5.1.
MY query is : https://drive.google.com/file/d/1Op_Ja292Bcnv0Ijxw6VdAxvGlfsdczmS/view

I got 30 seconds for above query. How can I use the "terms" query parser in my query?

Regards,
Vishal Patel
________________________________
From: Jason Gerlowski <[EMAIL PROTECTED]>
Sent: Friday, May 22, 2020 2:59 AM
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: Re: Query takes more time in Solr 8.5.1 compare to 6.1.0 version

Hi Jay,

I can't speak to why you're seeing a performance change between 6.x
and 8.x.  What I can suggest though is an alternative way of
formulating the query: you might get different performance if you run
your query using Solr's "terms" query parser:
https://lucene.apache.org/solr/guide/8_5/other-parsers.html#terms-query-parser
 It's not guaranteed to help, but there's a chance it'll work for you.
And knowing whether or not it helps might point others here towards
the cause of your slowdown.

Even if "terms" performs better for you, it's probably worth
understanding what's going on here of course.

Are all other queries running comparably?

Jason

On Thu, May 21, 2020 at 10:25 AM jay harkhani <[EMAIL PROTECTED]> wrote: