Re: [Dbmail] Literal date not implemented in the db_imap_append_msg() function. (dbmysql.c/dbpgsql.c)

2003-04-28 Thread Chris Nolan
This bug hit me as well. I got around it through writing my own conversion software that does set the internal date. A bug has been logged on this issue though, and the guys at IC&S will give me the code layout info I need to be able to fix it very soon. Chris Jeroen Hendriks wrote: Hi, W

Re: [Dbmail] All my mails in 1979!!!

2003-04-28 Thread Francisco Lozano
I'm running a Debian Woody system. My MTA is Postfix 1.1.11 as shipped with debian woody. My DB back-end is PostgreSQL 7.2.1, but I also have tried with a home-made-compilation of 7.3.2, getting the same problem. I'm using DBMail 1.1, and I followed the config params of the INSTALL file alm

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

2003-04-28 Thread jacques-beaudoin
I have over 3000 users 18000 emails on a uwimap server (2 pentiums II 266mhz 512meg memory) I migrate my users and email to a dbmail/innodb mysql server (2 pentiums III 550mhz xeon 1024meg memory) I get a drop in performance ? A webmail query on uwimap took 1 seconde A webmail query on dbmail

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

2003-04-28 Thread Aaron Stone
You would do well to look back in the archives and find the appropriate set of indices to add into the database. My system's performance increased dramatically by adding a few well places indices! Aaron On Sun, 27 Apr 2003 [EMAIL PROTECTED] wrote: > I have over 3000 users 18000 emails on a uwim

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

2003-04-28 Thread Paul Stevens
Aaron Stone wrote: You would do well to look back in the archives and find the appropriate set of indices to add into the database. My system's performance increased dramatically by adding a few well places indices! Here's the README.Debian contained in the debian packages. dbmail for Debia

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

2003-04-28 Thread Jacques Beaudoin
Could these indices (or index) be added to the dbmail install in the cvs Jacques Aaron Stone a écrit : > You would do well to look back in the archives and find the appropriate > set of indices to add into the database. My system's performance increased > dramatically by adding a few well places

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

2003-04-28 Thread Jacques Beaudoin
Why are all thoses mysql indexes not created in the dbmail cvs package Jacques Paul Stevens a écrit : > Aaron Stone wrote: > > You would do well to look back in the archives and find the appropriate > > set of indices to add into the database. My system's performance increased > > dramatically b

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

2003-04-28 Thread 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

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

2003-04-28 Thread Christopher Petrilli
On 4/28/2003, "Robert L. Tom" <[EMAIL PROTECTED]> wrote: > >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 a

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

2003-04-28 Thread Magnus Sundberg
Hi, It is on the roadmap that has been discussed earlier this month /Magnus http://mailman.fastxs.net/pipermail/dbmail/2003-April/002662.html Jacques Beaudoin wrote: Why are all thoses mysql indexes not created in the dbmail cvs package Jacques Paul Stevens a écrit : Aaron Stone wrote:

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

2003-04-28 Thread Paul Stevens
Robert, Robert L. Tom wrote: I applied these to my dbmail 1.1 mysql database.. 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!

[Dbmail] SMTP server for dbmail

2003-04-28 Thread Eelco van Beek
Hi all, I was thinking about building a dedicated smtp server for dbmail. This will not be a full smtp server implementation (no relaying and stuff like that) but pureley an smtp reception daemon. This has the following advantages: • much higher mail reception throughput • direct

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

2003-04-28 Thread Jacques Beaudoin
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