Hello everyone, We've recently started seeing a huge query time performance degradation with the use of the leading wildcard queries when we migrated from Solr 7.7.1 to Solr 8.6.3. The average response time was around 300 ms before the upgrade while around 600 ms after the upgrade. We have the exact same schema, solrconfig, and hardware for both versions. We're using JDK 11 and the index contains 10 million documents of total size of 5 GB.
Is there any know issue of using the leading wildcard in Solr 8.6.3? Why would the exact same query work better on an older version? Any help would be appreciated! Thank you!