Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Mark Mackay
On 25/9/02 4:21 AM, "Roel Rozendaal" <[EMAIL PROTECTED]> wrote: > The basic layout for dbmail was based upon pop3 but we are interested in > better schemes for imap. One of the main goals right now is to have the > fastest imap server around. Better table layouts would mean a great > improvement;

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Mike Watkins
Parsing is definitely the issue. I wrote a very simple Python application to parse headers in my dbmail inbox - a run against 50 messages takes about 4 seconds on a very fast box, using standard Python libraries. The question is, what's more important - message insertion or subsequent processi

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
Honestly I don't think using "select " or "select *" is a big speed difference - it's more like the ultimate fine tuning. I think dramatic results can be achieved by developing a table layout/imap logic that minimizes the number of queries and the amount of parsing done by the imap server. On Tue

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Ryan Butler
On Tue, 2002-09-24 at 10:48, Sam Przyswa wrote: > >Unless your program is getting back the rows as name value pairs and picking > through what gets sent back, you want to be specifying the columns and the > order > that they are to be sent back, not asking for everything and assuming that the > o

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Roel Rozendaal ([EMAIL PROTECTED]) écrivait: > >The basic layout for dbmail was based upon pop3 but we are interested in >better schemes for imap. One of the main goals right now is to have the >fastest imap server around. Better table layouts would mean a great >improvement; just don't know how mu

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
The basic layout for dbmail was based upon pop3 but we are interested in better schemes for imap. One of the main goals right now is to have the fastest imap server around. Better table layouts would mean a great improvement; just don't know how much time will be involved in implementing those. Thi

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Roel Rozendaal ([EMAIL PROTECTED]) écrivait: > >Why use messageblks? Well, for one reason, mysql has a limit on the record >size so a split-up is necessary anyway. The system was chosen to handle big >messages in chunks. > Ok, I guessed that there is a good reason to do that, but it's possible to

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
eric ([EMAIL PROTECTED]) écrivait: > >On Mon, 23 Sep 2002 18:48:33 -0700 in message <[EMAIL PROTECTED]>, Micah Stevens <[EMAIL PROTECTED]> wrote: >> Just a note, on your query comments, although I'm not arguing with your >> basic point, it's always been my understanding that SELECT statements that

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
3:52 PM Subject: RE: [Dbmail] Imapd is slow as hell > Micah Stevens ([EMAIL PROTECTED]) wrote: > > > >Just a note, on your query comments, although I'm not arguing with your > >basic point, it's always been my understanding that SELECT statements that > >use

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Micah Stevens ([EMAIL PROTECTED]) wrote: > >Just a note, on your query comments, although I'm not arguing with your >basic point, it's always been my understanding that SELECT statements that >use '*' instead of stating field names are slower. If you don't specify the >field names the database has

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread eric
On Mon, 23 Sep 2002 18:48:33 -0700 in message <[EMAIL PROTECTED]>, Micah Stevens <[EMAIL PROTECTED]> wrote: > Just a note, on your query comments, although I'm not arguing with your > basic point, it's always been my understanding that SELECT statements that > use '*' instead of stating field na

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Micah Stevens
s speed and discuss to find the best way to do. Shih Ming-Wei a dit : > My imap is working fine but pop3 is very slow, I have ask a few times > on the list but apparently nobody is interested :( > > Ming-Wei > > -Original Message----- > From: John Wall [mailto:[EMAIL PROTE

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
 : > My imap is working fine but pop3 is very slow, I have ask a few times > on the list but apparently nobody is interested :( > > Ming-Wei > > -Original Message- > From: John Wall [mailto:[EMAIL PROTECTED] > Sent: Monday, August 26, 2002 9:24 AM > To: dbmail@dbm

Re: [Dbmail] Imapd is slow as hell

2002-09-06 Thread Shane Kerr
On 2002-09-05 18:13:31 +0200, Shih Ming-Wei wrote: > Well, as I said, I tried it on 2 different newly installed platforms > (one intel and one sparc) in two different networks with 2 different > ip addresses. So the problem is really the pop3d on my system, 'cause > imapd is fast as hell and pop3d

RE: [Dbmail] Imapd is slow as hell

2002-09-05 Thread Shih Ming-Wei
6:03 PM To: dbmail@dbmail.org Subject: Re: [Dbmail] Imapd is slow as hell I am using both IMAP and POP3. I have about 1000 users and my dbmail system is very fast. I have no problems downloading 100 emails at a time in mere seconds. This is with amavisd-new/sophie/spamassasin/razor. I thin

Re: [Dbmail] Imapd is slow as hell

2002-09-05 Thread Bret Baptist
IL PROTECTED] > Sent: Tuesday, August 27, 2002 4:21 PM > To: [EMAIL PROTECTED] > Cc: dbmail@dbmail.org > Subject: RE: [Dbmail] Imapd is slow as hell > > > I set up dbmail with mysql (innodb) on a small machine (pII 366, 128 MB > > Which version of dbmail are you using? Is

RE: [Dbmail] Imapd is slow as hell

2002-09-05 Thread Shih Ming-Wei
PM To: [EMAIL PROTECTED] Cc: dbmail@dbmail.org Subject: RE: [Dbmail] Imapd is slow as hell > I set up dbmail with mysql (innodb) on a small machine (pII 366, 128 MB Which version of dbmail are you using? Is it RC3, or a more recent CVS version? Chris Hilts [EMAIL PROTECTED]

RE: [Dbmail] Imapd is slow as hell

2002-08-28 Thread Abdulla Damingo
ED] Sent: Wednesday, August 28, 2002 9:10 AM To: dbmail@dbmail.org Subject: Re: [Dbmail] Imapd is slow as hell Hi I have a problem using dbmail and fetchmail i'm not quit sure what the problem is maybe u can help me running suse7.3 with dbmail and all it requirements as well as fetc

Re: [Dbmail] Imapd is slow as hell

2002-08-28 Thread roel rozendaal
D]> To: Sent: Monday, August 26, 2002 9:24 AM Subject: [Dbmail] Imapd is slow as hell > Imapd is slow as hell. > > pop3d is fast when i press "send and recive" but on my imapd account it > takes up to a minute before it tryes to login. I heave allready check DNS > and my

RE: [Dbmail] Imapd is slow as hell

2002-08-28 Thread Shih Ming-Wei
try fetchmail -vvv to see more debug info, and share it with us Ming-Wei -Original Message- From: Abdulla Damingo [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 9:10 AM To: dbmail@dbmail.org Subject: Re: [Dbmail] Imapd is slow as hell Hi I have a problem using dbmail and

Re: [Dbmail] Imapd is slow as hell

2002-08-28 Thread Abdulla Damingo
ssage- > From: Shih Ming-Wei [mailto:[EMAIL PROTECTED] > Sent: Monday, August 26, 2002 4:57 PM > To: 'dbmail@dbmail.org' > Subject: RE: [Dbmail] Imapd is slow as hell > > Well just 1 test user with 1 test msg, I don't think tuning the > db would help much. With the

RE: [Dbmail] Imapd is slow as hell

2002-08-27 Thread Chris Hilts
> I set up dbmail with mysql (innodb) on a small machine (pII 366, 128 MB Which version of dbmail are you using? Is it RC3, or a more recent CVS version? Chris Hilts [EMAIL PROTECTED]

RE: [Dbmail] Imapd is slow as hell

2002-08-27 Thread Shih Ming-Wei
AM To: dbmail@dbmail.org Subject: Re: [Dbmail] Imapd is slow as hell What is wrong with the speed of pop3? We're running dbmail for 22.000 users all using pop3. No problems at all... Best regards, Eelco Shih Ming-Wei heeft op dinsdag, 27 aug 2002 om 10:51 (Europe/Amsterdam) het volgende geschreve

Re: [Dbmail] Imapd is slow as hell

2002-08-27 Thread
dbmail.org' Subject: RE: [Dbmail] Imapd is slow as hell Well just 1 test user with 1 test msg, I don't think tuning the db would help much. With the same condition the imap is fast as hell :) Ming-Wei -Original Message- From: Bret Baptist [mailto:[EMAIL PROTECTED] Sent: Monday, August

RE: [Dbmail] Imapd is slow as hell

2002-08-27 Thread Shih Ming-Wei
: Monday, August 26, 2002 4:57 PM To: 'dbmail@dbmail.org' Subject: RE: [Dbmail] Imapd is slow as hell Well just 1 test user with 1 test msg, I don't think tuning the db would help much. With the same condition the imap is fast as hell :) Ming-Wei -Original Message- Fro

RE: [Dbmail] Imapd is slow as hell

2002-08-26 Thread Micah Stevens
ng-Wei > > -Original Message- > From: John Wall [mailto:[EMAIL PROTECTED] > Sent: Monday, August 26, 2002 9:24 AM > To: dbmail@dbmail.org > Subject: [Dbmail] Imapd is slow as hell > > > Imapd is slow as hell. > > pop3d is fast when i press "send and recive"

RE: [Dbmail] Imapd is slow as hell

2002-08-26 Thread Shih Ming-Wei
t: Re: [Dbmail] Imapd is slow as hell On Monday 26 August 2002 04:43 am, Shih Ming-Wei wrote: > My imap is working fine but pop3 is very slow, I have ask a few > times on the list but apparently nobody is interested :( Have you checked out the suggested database indexing mentioned on the mailing l

Re: [Dbmail] Imapd is slow as hell

2002-08-26 Thread Bret Baptist
On Monday 26 August 2002 04:43 am, Shih Ming-Wei wrote: > My imap is working fine but pop3 is very slow, I have ask a few > times on the list but apparently nobody is interested :( Have you checked out the suggested database indexing mentioned on the mailing list? https://mailman.fastxs.nl/piper

Re: [Dbmail] Imapd is slow as hell

2002-08-26 Thread Bret Baptist
On Monday 26 August 2002 02:24 am, John Wall wrote: > Imapd is slow as hell. Have you checked out the database tuneups suggested on the mailing list? https://mailman.fastxs.nl/pipermail/dbmail/2002-April/000435.html Check that out. > > > /John > -- Bret Baptist Systems and Technical Support Sp

RE: [Dbmail] Imapd is slow as hell

2002-08-26 Thread Shih Ming-Wei
My imap is working fine but pop3 is very slow, I have ask a few times on the list but apparently nobody is interested :( Ming-Wei -Original Message- From: John Wall [mailto:[EMAIL PROTECTED] Sent: Monday, August 26, 2002 9:24 AM To: dbmail@dbmail.org Subject: [Dbmail] Imapd is slow as

[Dbmail] Imapd is slow as hell

2002-08-26 Thread John Wall
Imapd is slow as hell. pop3d is fast when i press "send and recive" but on my imapd account it takes up to a minute before it tryes to login. I heave allready check DNS and my host file. Imapd works fast sometimes and sometimes it slow as hell. I got only 3 users on that mailserver with dbmail.