I am using Solr 6.1.0. We have 2 shards and each has one replica. My schema field is below in one collection <dynamicField name="/*" type="text" indexed="true" stored="true" multiValued="true"/>
When I execute below query It is taking more than 180 milliseconds every time. http://10.38.33.24:8983/solr/forms/select?q=project_id:(2117627+2102977+2109667+2102912+2113720+2102976+2102478+2114939+2101443+2123237+2078189+2086596+2079707+2079706+2079705+2079658+2088340+2088338+2113641+2117131+2117672+2120870+2079708+2113718+2096308+2125462+2117837+2115406+2123865+2081232+2080746+2081239+2082706+2098700+2103039+2098699+2082878+2082877+2079994+2113719+2107255+2103251+2100558+2112735+2100036+2100037+2115359+2099330+2112101+2115360+2112070+2125140+2103656+2090184+2090183+2088269+2088270+2115358+2113036+2096855+2098258+2097226+2097225+2113127+2102847+2081187+2082817+2085678+2085677+2100937+2116632+2117133+2121028+2102479+2080006+2117509+2091443+2094716+2109780+2109779+2102735+2102736+2102685+2101923+2103648+2102608+2102480+2103664+2079205+2075380+2079206+2091442+2088614+2088613+2079876+2079875+2082886+2088615+2079429+2079428+2117185+2082859+2082860+2125270+2081301+2117623+2112740+2086757+2086756+2101344+2086597+2086847+2102648+2113362+2109010+2100223+2079877+2082704+2109669+2103649+2100744+2101490+2117526+2117134+2124020+2124021+2123524+2127200+2125039+2103663)&sort=updated+desc,id+desc&start=0&rows=30&fq=&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,appType,instance_group_id,bim_model_id,is_draft,InvoiceColourCode,InvoiceCountAgainstOrder,msg_content,msg_content1,msg_content3,user_ref,form_type_name,form_group_name,observationId,locationId,pf_loc_folderId,hasFormAssociation,hasCommentAssociation,hasDocAssociation,hasBimViewAssociation,hasBimListAssociation,originator_org_id,form_closeby_date,form_creation_date,status_change_userId,status_update_date,lastmodified,is_public,title,*Start_Date,*Tender_End_Date,*Tender_End_Time,*Tender_Review_Date,*Tender_Review_Time,*TenderEndDatePassed,*Package_Description,*Budget,*Currency_Sign,*allowExternalVendor,*Enable_form_public_link,*Is_Tender_Public&indent=off&shards.tolerant=true&shards=http://10.38.33.24:8983/solr/forms,http://10.38.33.227:8983/solr/forms&group=true&group.field=form_id&group.sort=msg_creation_date+desc&group.main=true When I execute below query It is taking less than 80 milliseconds every time. http://10.38.33.24:8983/solr/forms/select?q=project_id:(2117627+2102977+2109667+2102912+2113720+2102976+2102478+2114939+2101443+2123237+2078189+2086596+2079707+2079706+2079705+2079658+2088340+2088338+2113641+2117131+2117672+2120870+2079708+2113718+2096308+2125462+2117837+2115406+2123865+2081232+2080746+2081239+2082706+2098700+2103039+2098699+2082878+2082877+2079994+2113719+2107255+2103251+2100558+2112735+2100036+2100037+2115359+2099330+2112101+2115360+2112070+2125140+2103656+2090184+2090183+2088269+2088270+2115358+2113036+2096855+2098258+2097226+2097225+2113127+2102847+2081187+2082817+2085678+2085677+2100937+2116632+2117133+2121028+2102479+2080006+2117509+2091443+2094716+2109780+2109779+2102735+2102736+2102685+2101923+2103648+2102608+2102480+2103664+2079205+2075380+2079206+2091442+2088614+2088613+2079876+2079875+2082886+2088615+2079429+2079428+2117185+2082859+2082860+2125270+2081301+2117623+2112740+2086757+2086756+2101344+2086597+2086847+2102648+2113362+2109010+2100223+2079877+2082704+2109669+2103649+2100744+2101490+2117526+2117134+2124020+2124021+2123524+2127200+2125039+2103663)&sort=updated+desc,id+desc&start=0&rows=30&fq=&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,appType,instance_group_id,bim_model_id,is_draft,InvoiceColourCode,InvoiceCountAgainstOrder,msg_content,msg_content1,msg_content3,user_ref,form_type_name,form_group_name,observationId,locationId,pf_loc_folderId,hasFormAssociation,hasCommentAssociation,hasDocAssociation,hasBimViewAssociation,hasBimListAssociation,originator_org_id,form_closeby_date,form_creation_date,status_change_userId,status_update_date,lastmodified,is_public,title,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Start_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_End_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_End_Time,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_Review_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_Review_Time,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/TenderEndDatePassed,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Package_Description,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Budget,/myFields/FORM_CUSTOM_FIELDS/ORI_MSG_Custom_Fields/Currency_Sign,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/allowExternalVendor,/myFields/FORM_CUSTOM_FIELDS/ORI_MSG_Custom_Fields/Enable_form_public_link,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Is_Tender_Public&indent=off&shards.tolerant=true&shards=http://10.38.33.24:8983/solr/forms,http://10.38.33.227:8983/solr/forms&group=true&group.field=form_id&group.sort=msg_creation_date+desc&group.main=true In both query numFound="35572" and return records are 30. difference is only in fl. It is taking time, when I pass "*Start_Date,*Tender_End_Date,*Tender_End_Time,*Tender_Review_Date,*Tender_Review_Time,*TenderEndDatePassed,*Package_Description,*Budget,*Currency_Sign,*allowExternalVendor,*Enable_form_public_link,*Is_Tender_Public<http://10.38.33.24:8983/solr/forms/select?q=project_id:(2117627+2102977+2109667+2102912+2113720+2102976+2102478+2114939+2101443+2123237+2078189+2086596+2079707+2079706+2079705+2079658+2088340+2088338+2113641+2117131+2117672+2120870+2079708+2113718+2096308+2125462+2117837+2115406+2123865+2081232+2080746+2081239+2082706+2098700+2103039+2098699+2082878+2082877+2079994+2113719+2107255+2103251+2100558+2112735+2100036+2100037+2115359+2099330+2112101+2115360+2112070+2125140+2103656+2090184+2090183+2088269+2088270+2115358+2113036+2096855+2098258+2097226+2097225+2113127+2102847+2081187+2082817+2085678+2085677+2100937+2116632+2117133+2121028+2102479+2080006+2117509+2091443+2094716+2109780+2109779+2102735+2102736+2102685+2101923+2103648+2102608+2102480+2103664+2079205+2075380+2079206+2091442+2088614+2088613+2079876+2079875+2082886+2088615+2079429+2079428+2117185+2082859+2082860+2125270+2081301+2117623+2112740+2086757+2086756+2101344+2086597+2086847+2102648+2113362+2109010+2100223+2079877+2082704+2109669+2103649+2100744+2101490+2117526+2117134+2124020+2124021+2123524+2127200+2125039+2103663)&sort=updated+desc,id+desc&start=0&rows=30&fq=&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,appType,instance_group_id,bim_model_id,is_draft,InvoiceColourCode,InvoiceCountAgainstOrder,msg_content,msg_content1,msg_content3,user_ref,form_type_name,form_group_name,observationId,locationId,pf_loc_folderId,hasFormAssociation,hasCommentAssociation,hasDocAssociation,hasBimViewAssociation,hasBimListAssociation,originator_org_id,form_closeby_date,form_creation_date,status_change_userId,status_update_date,lastmodified,is_public,title,*Start_Date,*Tender_End_Date,*Tender_End_Time,*Tender_Review_Date,*Tender_Review_Time,*TenderEndDatePassed,*Package_Description,*Budget,*Currency_Sign,*allowExternalVendor,*Enable_form_public_link,*Is_Tender_Public&indent=off&shards.tolerant=true&shards=http://10.38.33.24:8983/solr/forms,http://10.38.33.227:8983/solr/forms&group=true&group.field=form_id&group.sort=msg_creation_date+desc&group.main=true>". but it is coming fast when pass "/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Start_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_End_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_End_Time,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_Review_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_Review_Time,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/TenderEndDatePassed,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Package_Description,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Budget,/myFields/FORM_CUSTOM_FIELDS/ORI_MSG_Custom_Fields/Currency_Sign,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/allowExternalVendor,/myFields/FORM_CUSTOM_FIELDS/ORI_MSG_Custom_Fields/Enable_form_public_link,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Is_Tender_Public<http://10.38.33.24:8983/solr/forms/select?q=project_id:(2117627+2102977+2109667+2102912+2113720+2102976+2102478+2114939+2101443+2123237+2078189+2086596+2079707+2079706+2079705+2079658+2088340+2088338+2113641+2117131+2117672+2120870+2079708+2113718+2096308+2125462+2117837+2115406+2123865+2081232+2080746+2081239+2082706+2098700+2103039+2098699+2082878+2082877+2079994+2113719+2107255+2103251+2100558+2112735+2100036+2100037+2115359+2099330+2112101+2115360+2112070+2125140+2103656+2090184+2090183+2088269+2088270+2115358+2113036+2096855+2098258+2097226+2097225+2113127+2102847+2081187+2082817+2085678+2085677+2100937+2116632+2117133+2121028+2102479+2080006+2117509+2091443+2094716+2109780+2109779+2102735+2102736+2102685+2101923+2103648+2102608+2102480+2103664+2079205+2075380+2079206+2091442+2088614+2088613+2079876+2079875+2082886+2088615+2079429+2079428+2117185+2082859+2082860+2125270+2081301+2117623+2112740+2086757+2086756+2101344+2086597+2086847+2102648+2113362+2109010+2100223+2079877+2082704+2109669+2103649+2100744+2101490+2117526+2117134+2124020+2124021+2123524+2127200+2125039+2103663)&sort=updated+desc,id+desc&start=0&rows=30&fq=&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,appType,instance_group_id,bim_model_id,is_draft,InvoiceColourCode,InvoiceCountAgainstOrder,msg_content,msg_content1,msg_content3,user_ref,form_type_name,form_group_name,observationId,locationId,pf_loc_folderId,hasFormAssociation,hasCommentAssociation,hasDocAssociation,hasBimViewAssociation,hasBimListAssociation,originator_org_id,form_closeby_date,form_creation_date,status_change_userId,status_update_date,lastmodified,is_public,title,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Start_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_End_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_End_Time,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_Review_Date,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Tender_Review_Time,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/TenderEndDatePassed,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Package_Description,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Budget,/myFields/FORM_CUSTOM_FIELDS/ORI_MSG_Custom_Fields/Currency_Sign,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/allowExternalVendor,/myFields/FORM_CUSTOM_FIELDS/ORI_MSG_Custom_Fields/Enable_form_public_link,/myFields/FORM_CUSTOM_FIELDS/Bid_Opportunity/Is_Tender_Public&indent=off&shards.tolerant=true&shards=http://10.38.33.24:8983/solr/forms,http://10.38.33.227:8983/solr/forms&group=true&group.field=form_id&group.sort=msg_creation_date+desc&group.main=true>". Why it is taking time when I am passing * in fl? Is there any other way for fast response? Regards, Vishal Patel
