Hi, I am using dbmail for several years. Recently I have made performance test of dbmail and cyrus. I have 350 users in dbmail with total 4 million mails. The biggest mailbox has a bit more than 150000 mails.
Then I created the same users for cyrus and with imapsync copied all mails from dbmail to cyrus. Yes, it took few days to finish. This is an test environment so I had exclusive access to it. Dbmail version 2.2.11 compiled from source Cyrus version 2.2.13-14+b3 (debian package) Both imaps use mysql for authentication. Database dbmail took 48G while cyrus mail storage had 30G for the same amount of mails. I run simple test with expect scripts and measuring time difference between establishing and closing connection to each imap. What I have got from tests is that search is much faster on dbmail and fetch is much faster on cyrus. For example on the mailbox which had 39661 unread mails search on cyrus imap took 20 seconds. The same operation on identical mailbox on dbmail took 12.7 seconds. On the other side, fetching headers from all mails in inbox with "fetch 1:* body[header]" took on dbmail 20 seconds while the same operation on cyrus took 3 seconds. I want to point that originaly I had mysql parameter tmp_table_size set to 30M and then search on dbmail took ages on 3000 big maibox. After I increased this parameter to 500M search was flying and tests mentioned above are done when tmp_table_size was set to 500M. I am using roundcube webmail as front end for dbmail imap server and after login it takes ages to open huge mailbox. I would appreciate if you know and tell me if there is any "trick" to increase speed of fetch on dbmail. Regards, Andreja _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
