Searching can be very slow when the search occurs against a meta criteria (for example a folder)

Versions / Builds Affected

Any

Status

Open

TT / JIRAID

2963

How to Identify

Consider the following scenario: - a high mailbox / user / email environment - there is a high number of archive stores - the server system is top notch, responsive and not "slow" in general Note: Looking at the samples below it is important to look at the time spans involved. A - PROBLEMATIC META BASED SEARCH when searching via the archive tab in folder view (this will cause the meta search criteria "folder" to be used) the search query is very slow and might even time out (hitting the 5min default WCF limit easily) * query 1, against folder, took 15min (each index ~20sec or so), hit timeouts * 2015-03-02,11:27:06,118,1,"#000069A8","#0000001A","info ","QueryEngine",">> Search request: structuredQuery {( ( ( Mats __and Holmstrand ) ) )} ... with containerKey I_efe32608ae429140b88fe6d7b176b0f2} ... 2015-03-02,11:27:06,119,1,"#000069A8","#0000001A","info ","QueryEngine","1 filtered user guids" 2015-03-02,11:27:06,119,1,"#000069A8","#0000001A","info ","QueryEngine","2015 Mar: Using meta (meta criteria specified)" 2015-03-02,11:27:07,237,1,"#000069A8","#0000001A","info ","QueryEngine","MailArchive2014M12: Using meta (meta criteria specified)" 2015-03-02,11:27:22,421,1,"#000069A8","#0000001A","info ","QueryEngine","MailArchive2014M10: Using meta (meta criteria specified)" 2015-03-02,11:27:53,245,1,"#000069A8","#0000001A","info ","QueryEngine","MailArchive2012M08: Using meta (meta criteria specified)" ... *** 20sec each, 61 in total *** … 2015-03-02,11:40:55,671,1,"#000069A8","#0000001A","info ","QueryEngine","MailArchive2014M11: Using meta (meta criteria specified)" 2015-03-02,11:41:16,818,1,"#000069A8","#0000001A","info ","QueryEngine","MailArchive2015M01: Using meta (meta criteria specified)" 2015-03-02,11:41:31,377,1,"#000069A8","#0000001A","info ","QueryEngine","MailArchive2015M02: Using meta (meta criteria specified)" 2015-03-02,11:41:45,616,1,"#000069A8","#0000001A","info ","QueryEngine","Running dtSearch query..." 2015-03-02,11:41:45,616,1,"#000069A8","#0000001A","info ","QueryEngine","limit: 5000" 2015-03-02,11:41:45,616,1,"#000069A8","#0000001A","info ","QueryEngine","query: [( ( ( Mats __and Holmstrand ) ) )]" 2015-03-02,11:41:45,646,1,"#000069A8","#0000001A","info ","QueryEngine","xfilter: (xfilter(word owners::efe32608ae429140b88fe6d7b176b0f2) __or xfilter(word owners::efe32608-ae42-9140-b88f-e6d7b176b0f2))" 2015-03-02,11:41:58,837,1,"#000069A8","#0000001A","info ","QueryEngine","Search OK" 2015-03-02,11:41:58,837,1,"#000069A8","#0000001A","info ","QueryEngine","Search produced 78 results" 2015-03-02,11:42:01,299,1,"#000069A8","#0000001A","info ","QueryEngine","<< Search request: structuredQuery {( ( ( Mats __and Holmstrand ) ) )} ... B - COMPARINGLY QUICK NON-META BASED SEARCH - when searching via advanced search without a meta search criteria the search is much quicker * query 2, not against folder, took 4sec * 2015-03-02,11:32:00,425,1,"#000069A8","#00000018","info ","QueryEngine",">> Search request: structuredQuery {( ( ( nora ) ) )} ... 2015-03-02,11:32:00,425,1,"#000069A8","#00000018","info ","QueryEngine","1 filtered user guids" 2015-03-02,11:32:00,425,1,"#000069A8","#00000018","info ","QueryEngine","2015 Mar: Not using meta (SQLCE & no meta criteria specified)" 2015-03-02,11:32:00,425,1,"#000069A8","#00000018","info ","QueryEngine","MailArchive2014M12: Not using meta (SQLCE & no meta criteria specified)" 2015-03-02,11:32:00,425,1,"#000069A8","#00000018","info ","QueryEngine","MailArchive2014M10: Not using meta (SQLCE & no meta criteria specified)" 2015-03-02,11:32:00,425,1,"#000069A8","#00000018","info ","QueryEngine","MailArchive2012M08: Not using meta (SQLCE & no meta criteria specified)" … *** all search within very short amount of time, 61 in total *** … 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","MailArchive2014M11: Not using meta (SQLCE & no meta criteria specified)" 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","MailArchive2015M01: Not using meta (SQLCE & no meta criteria specified)" 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","MailArchive2015M02: Not using meta (SQLCE & no meta criteria specified)" 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","Running dtSearch query..." 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","limit: 5000" 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","query: [( ( ( nora ) ) )]" 2015-03-02,11:32:00,436,1,"#000069A8","#00000018","info ","QueryEngine","xfilter: (xfilter(word owners::912d7fff923518429701bfc97c0e9381) __or xfilter(word owners::912d7fff-9235-1842-9701-bfc97c0e9381))" 2015-03-02,11:32:03,798,1,"#000069A8","#00000018","info ","QueryEngine","Search OK" 2015-03-02,11:32:03,799,1,"#000069A8","#00000018","info ","QueryEngine","Search produced 36 results" 2015-03-02,11:32:04,376,1,"#000069A8","#00000018","info ","QueryEngine","<< Search request: structuredQuery {( ( ( nora ) ) )} ...

Workaround / Fix Details

%

Required Actions

Consult with PSG / escalate