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. -- Charles Dostale System Admin - Silver Oaks Communications http://www.silveroaks.com/ 824 17th Street, Moline IL 61265 _______________________________________________ List info: http://lists.roundcube.net/users/
