Re: [Dbmail] dbmail-smtp slow

2004-10-31 Thread Ilja Booij
On Thu, 28 Oct 2004 09:43:25 +1300, Mark Mackay - Orcon <[EMAIL PROTECTED]> wrote: > We've disabled the quota checks in a 1.x version and it has produced a major > speed gain in the database. Previously our database was spiking to high > loads doing the SUM() calcs, so I wouldn't underestimate the

RE: [Dbmail] dbmail-smtp slow

2004-10-27 Thread Mark Mackay - Orcon
#x27;Ilja Booij'; 'DBMail mailinglist' Subject: RE: [Dbmail] dbmail-smtp slow > I don't think that disabling quota checks will get you any real speed > improvement. The real speed issues here are in the starting of the > dbmail-smtp process, setting up database connection etc. >

RE: [Dbmail] dbmail-smtp slow

2004-10-27 Thread Simon Gray
> I don't think that disabling quota checks will get you any real speed > improvement. The real speed issues here are in the starting of the > dbmail-smtp process, setting up database connection etc. > > As Paul indicated, we can get better performance if we enable > dbmail-smtp to receive several

Re: [Dbmail] dbmail-smtp slow

2004-10-25 Thread Jesse Norell
> I don't think that disabling quota checks will get you any real speed > improvement. The real speed issues here are in the starting of the > dbmail-smtp process, setting up database connection etc. The quota is calculated by sum()ing the sizes of all messages with status < 3 (iirc), so not c

Re: [Dbmail] dbmail-smtp slow

2004-10-23 Thread Ilja Booij
On Sat, 23 Oct 2004 14:52:56 +0400, Mikhail Ramendik <[EMAIL PROTECTED]> wrote: > Hello, > > Paul J Stevens wrote: > > > Of course, this whole setup is why Aaron wrote the lmtp daemon which > > fixes this for mta fed messages. For > > importing existing mailboxes, no such speedups are currently >

Re: [Dbmail] dbmail-smtp slow

2004-10-23 Thread Mikhail Ramendik
Hello, Paul J Stevens wrote: > Of course, this whole setup is why Aaron wrote the lmtp daemon which > fixes this for mta fed messages. For > importing existing mailboxes, no such speedups are currently > available. We need a tool (resurrect it > actually), that will bypass many of the checks db

Re: [Dbmail] dbmail-smtp slow

2004-10-23 Thread Paul J Stevens
Mikhail Ramendik wrote: Hello, It's somewhat strange, but mbox2dbmail is definitely slow on a large mail folder. Less than 2 mesages per second. There is no significant cpu usage, and large iowait time, so apparently it's all disk waiting. But the disk is not that slow (Seagate Barracuda 7200.7

[Dbmail] dbmail-smtp slow

2004-10-22 Thread Mikhail Ramendik
Hello, It's somewhat strange, but mbox2dbmail is definitely slow on a large mail folder. Less than 2 mesages per second. There is no significant cpu usage, and large iowait time, so apparently it's all disk waiting. But the disk is not that slow (Seagate Barracuda 7200.7). I suspected slow Pytho