Use MySQL to store messages for faster GUI and quick searches

[rcubetrac]

Reported by calande on 6 Nov 2007 22:27 UTC as Trac ticket #1484652

I think it would be a good idea to have a script for e-mail piping so that the mail server redirects all incoming mails to this PHP script to add the email body to the MySQL database in real time, and possible attachments to an "attachment" directory in the file system.

IMAP is slow when you have gigs of emails and attachments. If you store all emails into the database in real time, if you store all attachments into the file system, and if you set up a cron job to index the database, you can have 2-3 gigs of emails, this is not a problem, your webmail will be very fast to display the inbox, and searches will be very fast too. You just have to reference the address of the attachment location for each email that has an attachment.

To sum up: Store email text in the database and store attachments on the file system.

Speed is a major problem with IMAP and webmails in general. This is because emails are not stored and indexed in a database. If you solve this problem, people are going to leave Squirrelmail and Horde and are going to rush to Roundcube right away. Speed is Gmail's #1 advantage. Nowadays, everybody uses Gmail.

Migrated-From: http://trac.roundcube.net/ticket/1484652

[rcubetrac]

Comment by @thomascube on 7 Nov 2007 07:48 UTC

Speed mostly depends on the IAMP server's performance. What you are asking for is not a !RoundCube feature but a complete mail server + webmail solution. RC is meant to be a simple and lightweight IMAP client. RC caches messages in the local database and there were many discussions about wether !RoundCube should also build it's own fulltext index for faster searching. The devs agreed to leave this up to the IMAP server.

[rcubetrac]

Status changed by @thomascube on 7 Nov 2007 07:48 UTC

new => closed