Thanks for your reply. Actually, there are 100 fields including below field in our schema file for single collection.
<dynamicField name="/myField*" type="text" indexed="true" stored="true" multiValued="true"/> We are passing specific fields name in fl parameter but when required to get dynamic field at that time only we pass *fieldtext with other fields in fl parameters. If we are passing fl=* then result will come fast but when we are passing * in front of field, then result is coming slow. we are passing like this fl=id,form_id,project_id,doctype,dc,form_type_id,status_id,originator_user_id,controller_user_id,form_num,originator_proxy_user_id,originator_user_type_id,controller_user_type_id,msg_id,msg_originator_id,msg_status_id,parent_msg_id,msg_type_id,*msg_code,*form_code Same things we were passing in Solr 6.1.0 but it is coming fast. issue is in Solr 8.9.0. how can we resolve our issue? Regards, Vishal ________________________________ From: Jan H?ydahl <jan....@cominvent.com> Sent: Friday, November 12, 2021 6:35 PM To: users@solr.apache.org <users@solr.apache.org> Subject: Re: Return field with astrick(*) is going to slow in Solr 8.9.0 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.
