title: Timeout problems with Microsoft Office SharePoint Server 2007 Query Web Service
body: <p>We are having issues with the MOSS 2007 Web Service. Specifically, the Query/QueryEx method of the API. </p>
  
  <p>We are using the SQL Syntax to query sharepoint, and for most cases, our search execution time is very fast. However, when we add filters and sorts, things start slowing down. In some cases we even get an error.</p>
  
  <p>For example, this MSSQLFT query will give a System.ServiceProcess.TimeoutException exception about 50% of the time. The timeout will occur around the 10 seconds mark.</p>
  
  <pre><code>SELECT WorkId, Rank, ... , PerforceFolder, PerforceDateSubmitted FROM SCOPE() 
  WHERE "scope"='Tech_Depot'  AND (FileExtension = 'cpp' )  
  ORDER BY PerforceDateSubmitted, Rank DESC
  </code></pre>
  
  <p>Is there any settings / query parameter / etc... we can use to allow a bigger SEARCH execution time on the sharepoint back-end? </p>