Re: Moving Archived Messages Out of Database

2017-03-28 Thread Matthieu Baechler
A possible way to do that is to create another account for your user and moving the emails on this account, I guess. You then can make sure this account is only used with POP3. -- Matthieu Baechler Le 27/03/2017 à 18:41, Jerry Malcolm a écrit : I'm using MySQL. I'd love to get better

Re: Moving Archived Messages Out of Database

2017-03-27 Thread Jerry Malcolm
I'm using MySQL. I'd love to get better performance on large folders. However, I'd prefer to make clients move old archive folders completely off the server and store locally (the way POP3 does). Since IMAP doesn't support doing that directly, I'm looking for suggestions on how to move

Re: Moving Archived Messages Out of Database

2017-03-27 Thread Matthieu Baechler
Hi, I can confirm what Benoit said : making large mailboxes fast is not a easy task. However, it's not impossible to do, it's just a matter of preparing the data for SELECT to being fast. What mailbox backend are you using ? Regards, -- Matthieu Baechler Le 27/03/2017 à 08:23, Benoit

Re: Moving Archived Messages Out of Database

2017-03-27 Thread Benoit Tellier
Hi Jerry, We also have some performance troubles while opening large mailboxes as well. This is something the team is currently working on. To make it short : - Opening a new, large mailbox implies removing RECENT flags from all the stored messages (no choices) - Then you have to build the MSN