Outlook 2007 MailItem Info - slow

Question

I'm trying to parse through e-mails in Outlook 2007. I need to streamline it as fast as possible and seem to be having some trouble.

Basically it's:

foreach( Folder fld in outllookApp.Session.Folders )
{
    foreach( MailItem mailItem in fld )
    {
        string body = mailItem.Body;
    }
}

and for 5000 e-mails, this takes over 100 seconds. It doesn't seem to me like this should be taking anywhere near this long.

If I add:

string entry = mailItem.EntryID;

It ends up being an extra 30 seconds.

I'm doing all sorts of string manipulations including regular expressions with these strings and writing out to database and still, those 2 lines take 50% of my runtime.

I'm using Visual Studio 2008

Answer 1

I do not know if this will address your specific issue, but the latest Office 2007 service pack made a synificant performance difference (improvement) for Outlook with large numbers of messages.

Answer 2

Are you just reading in those strings in this loop, or are you reading in a string, processing it, then moving on to the next? You could try reading all the messages into a HashTable inside your loop then process them after they've been loaded--it might buy you some gains.

Any kind of UI updates are extremely expensive; if you're writing out text or incrementing a progress bar it's best to do so sparingly.

Answer 3

Doing this kind of thing will take a long time as you having to pull the data from the exchange store for each item.

I think that you have a couple of options here..

Process this information out of band use CDO/RDO in some other process. Or Use MapiTables as this is the fastest way to get properties there are caveats with this though and you may be doing things in your processin that can be brought into a table.

Redemption wrapper - http://www.dimastr.com/redemption/mapitable.htm

MAPI Tables http://msdn.microsoft.com/en-us/library/cc842056.aspx

Answer 4

We had exactly the same problem even when the folders were local and there was no network delay.

We got 10x speedup by storing a copy of every email in a local Sql Server CE table tuned for the search we needed. We also used update events to make sure the local database remains in sync with the Outlook/Exchange folders.

To totally eliminate user lag we took the search out of the Outlook thread and put it in its own thread. The perception of lagging was worse than the actual delay it seems.