[Dbmail] Dbmail] Dbmail imap speed (is it slower then uwimap)

[Robert L. Tom]

I applied these to my dbmail 1.1 mysql database..

Optimizing your tables
-----------------



I found dbmail to become increasingly useless without additional
indexes. Speed increases as dramatically as server load drops
after adding these.


mysql:


alter table mailboxes add index (name);
alter table mailboxes add index (owner_idnr);
alter table mailboxes add index (is_subscribed);
alter table messages add index (mailbox_idnr);
alter table messages add index (seen_flag);
alter table messages add index (unique_id);   <--Got an ERROR right here
alter table messages add index (status);      <-- also here.

But  I got an error on the last two lines from mysql saying they
don't exists!

Robert