Would like to know if anything helped ?. We are trying to upgrade from 9.3 to 
9.8 and seeing performance degradation in query . Please share your experience 
if you have also noticed any query perf degradation

Thanks

On 2/7/25, 5:32 AM, "Pavel Chumakou" <pavel.chuma...@gmail.com 
<mailto:pavel.chuma...@gmail.com>> wrote:


[You don't often get email from pavel.chuma...@gmail.com 
<mailto:pavel.chuma...@gmail.com>. Learn why this is important at 
https://aka.ms/LearnAboutSenderIdentification 
<https://aka.ms/LearnAboutSenderIdentification> ]


Hi all,


After migrating from* Solr 9.6.1* to *Solr 9.7.0 *we discovered significant
query performance degradation. Solr 9.7 works approximately 1.5-3 times
slower than Solr 9.6.1 under the same conditions (the same Solr
configuration, the same collection, the same user queries and query load).


We tried to run Solr 9.7 with Java 17 and Java 21, Windows and Linux,
enabling and disabling *multiThreaded *and*
MMapDirectory.enableMemorySegments *parameters. Results are always the
same: significant performance degradation for Solr 9.7 compared to Solr
9.6.1.


Our documents contain 3-9 text fields, user queries are Boolean with *OR *logic
(q.op=OR), *edismax *query parser, *qf *parameter contains 6 text fields.
To eliminate possible influence of our custom libraries and data, we
created independent Solr search performance benchmark:
https://github.com/pavel-chumakou/solr-benchmark 
<https://github.com/pavel-chumakou/solr-benchmark>
This Solr benchmark tool is based on public data (Wikipedia articles) and
can be easily reproduced.


Currently we have the following test results:
*Solr 9.6.1*
Search time, ms: 1564 694 554 447 474 404 359 352 453 475 524 413 560 395
432 403 397 353 367 487


*Solr 9.7.0*
Search time, ms: 2453 1650 1447 1593 1527 1380 1335 1293 1454 1341 1747
1753 1648 1383 1296 1246 1279 1238 1205 1396


Any advice on how to improve Solr 9.7/Solr 9.8 search performance? We
really don't want to migrate back to Solr 9.6.1.


Thanks.



Reply via email to