none
[E2003] [WebDAV] Simple searches very slow to execute RRS feed

  • Question

  • Hello

    I'm using WebDAV to get mail from Exchange 2003.

    It's working fine, apart from on one account, where even simple search requests are taking ages to execute.

    For instance this simple request is taking 5 seconds, on a folder with about 200 items in it:

    <searchrequest ><sql>SELECT "urn:schemas:httpmail:read" FROM Scope('SHALLOW TRAVERSAL OF ""')WHERE ("urn:schemas:httpmail:datereceived" &gt; CAST("2011-02-20T16:14:20.094Z" as 'dateTime'))</sql></searchrequest>
    

    Only search requests with any "where" clauses seem to take a long time, if there are no restrictions it returns quickly. It happens in all folders on the account. Some search queries are taking 40 seconds to execute.

    It just seems to be on one account, the same search on another account will execute in a few milliseconds. Sadly I don't have admin rights to the server.

    Does anyone have any idea why it's taking so long?

     

    Thanks

    Tom


    Saturday, May 21, 2011 3:29 PM

All replies

  • Could be a sign of some sort of underlying database problem a few simple things you can do to test this is export that mailbox and reimport the data into a test mailbox and then retry your queries against the same data in a different mailbox. If the mailbox isn't very large and you have other Mail Stores/Server or storage groups you could try moving that mailbox to a different location/server which would rule out the possiblity of any Db issues.

    Cheers
    Glen

     

    Monday, May 23, 2011 3:25 AM
  • Thanks for the suggestion, Glen.

    I tried exporting all items in the mailbox to a local Exchange 2003 server, and I have no performance problems at all (even on a test folder with over 20,000+ items).

    Back on the real live server, there are no performance issues when searching the mailbox via Outlook.

    So the big mystery is why are WebDAV requests taking ages when Outlook is almost instant? 

    Thanks again for your help!

    Cheers
    Tom


    Monday, May 23, 2011 8:49 PM
  • Oultook maybe using a Content Index Query while your query is using a restriction on the folder if there is a database problem for that mailbox then this would explain that type of problem if you can move the mailbox to another store that should fix any restriction problems (an Export/Delete/Import would achieve the same thing) otherwise you would need to use a tool like isinteg to scan and fix this type of problem which would require taking the store offline and potentially a long downtime period. You might also want to have a read of http://blogs.msdn.com/b/webdav_101/archive/2008/03/12/how-can-i-increase-webdav-performance.aspx which links to a KB on how you can do CI queries with WebDAV.

    Cheers
    Glen

    Tuesday, May 24, 2011 3:44 AM