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).
I suspected slow Python handling of mbox at first. So, I have hacked the
script so it only processes the mbox without calling dbmail - and then
it was VERY fast.
So, it seems that dbmail-smtp is actually quite slow. Why could that be?
dbmail-smtp will create a database connection, insert the message in a temp storage, check quota for the user
in question, insert the mail in its final location, and close the connection. And that for each message fed to
it. 2 messages per second is actually not that bad.
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 dbmail-smtp performs, or perhaps a tool that will just keep the
database connection alive. Perhaps being able to feed dbmail-smtp several messages in a single pipe will be
feasible.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
