probably the 64 mb that's nagging you.
7000 e-mail messages isn't that extreme, i've got much more in some of
my folders, it works perfectly :D
Eelco
On zondag, feb 9, 2003, at 23:17 Europe/Amsterdam, 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
_________________________
E.J.A. van Beek
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
PGP-key:
www.ic-s.nl/keys/eelco.txt
