hi
a couple of weeks ago i had exactly the same problem. it took me "hours"
to delete some mails via imap.
i reported my problem to the mailinglist and got a "you have to purchase
more rams" response.
i upgraded the whole machine from pII 450/256mb ram to celeron
1700/256mb sdram. now it performes great! i'm still waiting for my new
rams but it they arn't necessary any more.
imho mysqld isnt a database which performes very well on "low-end
workstations". the problem is definitively NOT! dbmail - the problem is
the db (mysqld / postgresql) !
hope that helps you and doesn't cost you too much :)
best regards, armin.
Ulrich Spoerlein wrote:
Ok, I wanted an overall solution for my Email "Problem". Problem,
because I have about 7500 Emails in one folder (high-volume
maillinglist). I know I could make "monthly-folders" but I don't like
that approach. I always wanted Email to go into some sort of database
and have IMAP as a front-end.
Sadly the performance with such a system sucks :(
Ok, I did the following, to get the Maildir Folder into the database
(MySQL running on a P200, 64MB):
foreach file in *;do cat $file|dbmail-smtp -u q; done
I know, this approach is bound to suck, but after 2h all Emails were in
(database size: 45MB). I then access my IMAP INBOX with Sylpheed from my
Workstation via Fast-Ethernet. Took roughly a minute :(
I then created a folder with the name of the mailinglist and tried to
move all the Mails into that folder. After 3h I killed sylpheed and shut
down dbmail+mysql.
Is this slowness expected? Are you really using TCP for the database
connect? Why not rely on Unix-sockets (should be faster, not?)
Does anybody here have experience with bigger Mail folders on
"home-sized servers"?
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
