I think doing caching of messages is not at all a good idea. I usually use more than one mail reader: sometimes roundcube at work, others squirrel and sometimes pine, all depending on from which machine I'm connecting to see the mail. If we cache the messages into DB, only Roundcube will know it and sometimes it may be different from IMAP server. It's the same problem as using Outlook: it keeps messages locally, not on IMAP/POP server.

So, if finally you decide to enable messages cache feature, it should be an option, that will be enabled only for those who only use RoundCube and whose know there are not thousands of messages for thousands of users.

Personally, I vote -1 for that.

Ah! saving messages to files into RC server instead of DB... you'll lose all DB improvements, as transactional one: if there is any problem with electricity it may corrupt files and lose info. For this, I vote -1000.

See you,
emi

2008/6/11 Алексей Михеев <amiheev@st-host.ru>:

I think, that could make sense, if those caches would be flushed
regularly depending no how many users are there. And I don't think,
mysql would be too good for that, I'd prefer some kind of serialized
data in files.

On Wed, 11 Jun 2008 11:30:36 +0200
Andreas <andreas@unstable.nl> wrote:

> On Wed, Jun 11, 2008 at 09:32:51AM +0200, Thomas Bruederli wrote:
> > This will probably bloat the database like hell. Consider thousands
> > of users having thousands of messages with attachments. If the size
> > of the database grows, it takes even longer to load data because of
> > a higher seeking time. Also opening a single message is less
> > expensive than listing hundred of headers. This is why we just
> > cache headers.
>
> Would it help if you only request the 20-some headers that are to be
> displayed? If the IMAP server does the sorting, RoundCube doesn't
> need to know about all of the messages in a folder.
>

--
Aleksei "rusty_angel" Miheev
ST-Hosting
mailto:amiheev@st-host.ru
xmpp:aleksei@jabber.miheev.info
+7 (8313) 244 000
_______________________________________________
List info: http://lists.roundcube.net/dev/