On Aug 26, 2009, at 3:30 PM, Gavin McCullagh wrote:
Hi,
we have a debian lenny server running postgresql 8.3, php 5 and moodle 1.9.5. We have a mail server running cyrus-imapd adjacent to it. For various reasons, we installed roundcube on the moodle server to be a front-end to the cyrus imapd on the other server.
I use PostgreSQL and do not have performance issues, although I don't
have thousands of messages in any mailboxes.
I have turned off message caching because it did not increase
performance, although I'm not using the latest RC.
( IMHO, message caching should be done via HTML 5 local storage, but
that's off topic )
Also, when I upgrade I drop the existing database and create a new,
fresh DB.
Yeah, this loses some data, but RC isn't the primary access to our
user's e-mail, it is for remote use only.
I did a diff of the PostgreSQL SQL files between 0.2.2 and 0.3RC1 :
chasd$ diff roundcubemail-0.2.2/SQL/postgres.initial.sql
roundcubemail-0.3-RC1/SQL/postgres.initial.sql
0a1,2
-- RoundCube Webmail initial database structure
chasd$ diff roundcubemail-0.2.2/SQL/postgres.update.sql
roundcubemail-0.3-RC1/SQL/postgres.update.sql
chasd$
No difference in the schema.
If you have two separate databases for the two versions, you can
compare the output of
pg_dump -s -d <databasename>
from the two databases.
cyrus might also be something to look at.
Many on the RC users list have mentioned that dovecot was faster when
they switched from other IMAP servers.
I'm not saying you should switch your production environment, but
setting up a test instance of dovecot, copying your mailboxes over,
and pointing a test instance of RC at that dovecot might be an
interesting test.
Yeah, and cyrus has features dovecot doesn't have.