I am using solr 6.1.0. We have 2 shards and each has one replica. Our index size is very large. I find out that position of field in query will impact of performance.
If I made below query I got slow response (doc_ref:((*KON\-N2*) )) AND (title:((*cdrl*) )) AND project_id:(2104616) AND is_active:true AND ((isLatest:(true) AND isFolderActive:true AND isXref:false AND -document_type_id:(3 7) AND ((is_public:true OR distribution_list:11111 OR folderadmin_list:11111 OR author_user_id:11111) AND (((allowedUsers:(11111) OR allowedRoles:(2222 6440215 6368478) OR combinationUsers:(11111)) AND -blockedUsers:(11111)) OR (defaultAccess:(true) AND -blockedUsers:(11111) AND -blockedRoles:(2222 6440215 6368478))))) OR (isLatestRevPrivate:(true) AND allowedUsersForPvtRev:(11111) AND -folderadmin_list:(11111))) If I changed (doc_ref:((*KON\-N2*) )) AND (title:((*cdrl*) )) part in last then got fast response compare to above. project_id:(2104616) AND is_active:true AND ((isLatest:(true) AND isFolderActive:true AND isXref:false AND -document_type_id:(3 7) AND ((is_public:true OR distribution_list:11111 OR folderadmin_list:11111 OR author_user_id:11111) AND (((allowedUsers:(11111) OR allowedRoles:(2222 6440215 6368478) OR combinationUsers:(11111)) AND -blockedUsers:(11111)) OR (defaultAccess:(true) AND -blockedUsers:(11111) AND -blockedRoles:(2222 6440215 6368478))))) OR (isLatestRevPrivate:(true) AND allowedUsersForPvtRev:(11111) AND -folderadmin_list:(11111))) AND (doc_ref:((*KON\-N2*) )) AND (title:((*cdrl*) )) Is it possible? How does Solr execute this query? field sequence is matter for performance? I want to know the step by step Solr query execution same like database query because I will arrange field for better performance. Regards, Vishal Sent from Outlook<http://aka.ms/weboutlook>
