Beware of the 'useDocValuesAsStored' setting which I believe is newer than 6.x Read more here https://solr.apache.org/guide/8_10/docvalues.html#retrieving-docvalues-during-search
I think that may be what you're seeing. So what it will do is to try to return data from every field in the index even if they are not stored -- if it has docValues. Which will be very expensive for a fl=* query. Best practice is to exactly specify what fields that you require instead of using *. Or change your useDocValuesAsStored setting. Jan > 12. nov. 2021 kl. 11:57 skrev VIshal Patel <vishalpatel202...@outlook.com>: > > Hello, > > > We have upgraded Solr from 6.1.0 to 8.9.0. After upgrade we are facing > slowness when returning field with *. > > > Solr 8.9.0 [300 milliseconds] > http://XX.XX.XX.XX:XXXX/solr/forms/select?q=id%3AFORM27248682964899&fl=*ORI_FORMTITLE> > > Solr 6.1.0 [15 milliseconds] > http://XX.XX.XX.XX:XXXX/solr/forms/select?q=id:FORM1011547110139542&&fl=*ORI_FORMTITLE > > Can someone check and suggest possible root cause/changes to solve this issue. > > Regards, > Vishal.
