All, First off I love what the developers are doing with dbmail. An awesome idea that addresses several issues I have been having with retention and centralized storage with almost infinite scalability.
My only issue was performance coming from using a courier-imap with postfix. Now, with these index additions of Paul's has improved my performance to almost the same as courier-imap. Has anyone had any issues with these modifications? Are there any draw backs the the indexes? I plan on making dbmail the center piece of a scalable mail hub that will include other feature and am wondering what kind of large scale, both number of users and message throughput per day, people have set up and in production. Thanks for all the great information on this list and the the dbmail developers, keep up the excellent work. Thanks again, Rich On Wed, 2003-04-02 at 16:57, Paul Stevens wrote: > 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 > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > >
