Ryan Butler wrote:
Do you have a alter table statement floating around that modifies the
stock table to use your indexes and constraints?
Hi Ryan,
I'm currently using:
alter table mailboxes add index (owner_idnr);
alter table mailboxes add index (name);
alter table mailboxes add index (is_subscribed);
alter table messages add index(mailbox_idnr);
alter table messages add index(seen_flag);
alter table mailboxes add foreign key (owner_idnr) references
users(user_idnr) on delete cascade;
alter table messages add foreign key (mailbox_idnr) references
mailboxes(mailbox_idnr) on delete cascade;
alter table messageblks add foreign key (message_idnr) references
messages(message_idnr) on delete cascade;
But mind you, I'm no innodb nor sql expert. My experience is mostly
limited to good-old (my)isam limited sql. So any ideas for improvements
that are actually based on a closer examination of the actual queries
used by dbmail are most welcome I'm sure. I guess more experience with
larger deployments will tell.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
