Re: [Dbmail] dbmail + mysqld settings

2003-05-10 Thread Robert L. Tom
Thanks. :) Robert > Hi Tom > > These are the lines: > > USE dbmail; > > 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 (se

Re: [Dbmail] dbmail + mysqld settings

2003-05-10 Thread jacques-beaudoin
Hi Tom These are the lines: USE dbmail; 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 ind

Re: [Dbmail] dbmail + mysqld settings

2003-05-09 Thread Robert L. Tom
Jacques, Were those the ones about new indexes and tables to add on dbmail? Robert > Take a look at the archive i ask 2 or 3 weeks ago about > the speed of dbmail compare to uwimap. > > Somebody give me 6 or 7 sql statements to add to dbmail. > > The response time after addind the statements made

Re: [Dbmail] dbmail + mysqld settings

2003-05-09 Thread jacques-beaudoin
Take a look at the archive i ask 2 or 3 weeks ago about the speed of dbmail compare to uwimap. Somebody give me 6 or 7 sql statements to add to dbmail. The response time after addind the statements made dbmail 70% faster Jacques "Robert L. Tom" <[EMAIL PROTECTED]> a dit : > > I am using db

[Dbmail] dbmail + mysqld settings

2003-05-08 Thread Robert L. Tom
I am using dbmail 1.1 with mysql. I have these default settings below for mysqld. Is there anything I need to make larger or smaller to make mysql faster working with DBmail? Robert Possible variables for option --set-variable (-O) are: back_log current value: 50 bdb_cache_size