Right on Aaron .... I just alter my dbmail tables and like you say:
> 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); > alter table messages add index (status); Thanks again Aaron
