id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
1484652,Use MySQL to store messages for faster GUI and quick searches,calande,,"I think it would be a good idea to have a script for [http://www.emailsoftwaretools.com/emailpiping.html 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.",Feature Requests,closed,5,,Core functionality,0.1-rc2,normal,wontfix,,