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


Any one is looking this issue?
I got same issue.

Regards,
Vishal Patel

________________________________
From: jay harkhani <[EMAIL PROTECTED]>
Sent: Wednesday, May 20, 2020 7:39 PM
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: Query takes more time in Solr 8.5.1 compare to 6.1.0 version

Hello,

Currently I upgrade Solr version from 6.1.0 to 8.5.1 and come across one issue. Query which have more ids (around 3000) and grouping is applied takes more time to execute. In Solr 6.1.0 it takes 677ms and in Solr 8.5.1 it takes 26090ms. While take reading we have same solr schema and same no. of records in both solr version.

Please refer below details for query, logs and thead dump (generate from Solr Admin while execute query).

Query : https://drive.google.com/file/d/1bavCqwHfJxoKHFzdOEt-mSG8N0fCHE-w/view

Logs and Thread dump stack trace
Solr 8.5.1 : https://drive.google.com/file/d/149IgaMdLomTjkngKHrwd80OSEa1eJbBF/view
Solr 6.1.0 : https://drive.google.com/file/d/13v1u__fM8nHfyvA0Mnj30IhdffW6xhwQ/view

To analyse further more we found that if we remove grouping field or we reduce no. of ids from query it execute fast. Is anything change in 8.5.1 version compare to 6.1.0 as in 6.1.0 even for large no. Ids along with grouping it works faster?

Can someone please help to isolate this issue.

Regards,
Jay Harkhani.