I'm surprised that your fl=*ORI_FORMTITLE syntax works, as it is not a documented feature (https://solr.apache.org/guide/8_10/common-query-parameters.html#fl-field-list-parameter)
Jan > 15. nov. 2021 kl. 06:44 skrev VIshal Patel <vishalpatel202...@outlook.com>: > > 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. >
