Imap does not work on big databases

[sebp]

I've tested imap with a fresh installation of alfresco community 3.2r. After resolving an issue (ETHREEOH-3199) it was working quite ok on the nearly empty database. I was able to see all folders of the database as imap folders in outlook express. After copying our production database into the test system I tried to refresh the imap folders in outlook. Outlook connected to alfresco and started to refresh but alfresco wasn't answering for minutes. I found out that the ImapServiceImpl tries to get all folders of the whole database from the fileFolderService. This takes hours. And this happens every time when a user wants to see the available alfresco imap folders. Even limiting the amount of amount of imap folders using mountpoints doesnt reduce the time to wait to a level that is acceptable in production use. I could imagine that it would help if:
1. Users could set mountpoints manually on the folders they need as imap folders
2. Alfresco caches the imap folders it found in the first search and then updates this cache if folders are added/removed under one of the mount points.
Is there any way to do this already? Or, are these features planned for future releases?

[gravitonian]

Hi,

There is another product called OpsMailmanger for Alfresco that you could try.
It would be interesting to see your experience with it compared to Alfresco IMAP.

You can signup for a trial here: https://www.opsera.com/opsacct/registration/create

Cheers,
Martin Bergljung
Opsera

[icart]

I'm having the same problem. The moment I threw real data at it, it lost the ability to build the directory tree on Outlook and Thunderbird. So, is this the final word? Is the IMAP feature simply not ready for prime time and OpsMailManager the only solution?

[sebp]

I've managed to run IMAP by using mount points to reduce the number of spaces available via imap. Nevertheless it takes a very long time to list the imap folders in outlook or synchronize them.

[icart]

Mountpoints hmm…. I ran into a post elsewhere in the Forums where someone was trying to set the mount points to users individual homes. I tried it without success. The setting I used in alfresco-global.properties are below. As part of my evaluation of Alfresco, I dumped about 16 Gig worth of documents into Alfresco's respository to see if it would choke. So far, only IMAP seams to be stalled. Anyway I appreciate the reply. Any additional advice would be greatly appreciated.

imap.config.home.store=${spaces.store}
imap.config.home.rootPath=/${spaces.company_home.childname}
imap.config.home.folderPath=Imap Home

imap.config.server.mountPoints=Alfresco IMAP
imap.config.server.mountPoints.default.mountPointName=IMAP
imap.config.server.mountPoints.default.modeName=ARCHIVE
imap.config.server.mountPoints.default.store=${spaces.store}
imap.config.server.mountPoints.default.rootPath=/${spaces.company_home.childname}
imap.config.server.mountPoints.value.AlfrescoIMAP.mountPointName=Alfresco IMAP
imap.config.server.mountPoints.value.AlfrescoIMAP.modeName=MIXED