Hmm that's not quite efficient.. Could you send the imap commands
outlook is executing? You'll find them in the log; try the following:
tail -f /var/log/mail.log | grep imap4d | grep COMMAND
regards roel
Johan Ekenberg heeft op maandag, 14 apr 2003 om 12:01
(Europe/Amsterdam) het volgende geschreven:
Hi!
I'm evaluating dbmail for a large mailsystem which is required to
handle just a small number of mailboxes but with a very large number
of mail in each, at least 200000 per mailbox.
So, I imported ~39000 mail into dbmail 1.1 and connected by IMAP with
MS Outlook. I see that dbmail runs a very time consuming query *each
time* I request a message:
SELECT message_idnr, seen_flag, recent_flag
FROM messages
WHERE mailbox_idnr = 1 AND status<2 AND unique_id!=""
ORDER BY message_idnr ASC
This query takes about 1.5 sec with 39000 mail so it will be
impossible with 200k mail. Is there anything to do about this? Is this
query really necessary for each read mail? In my mind, the main
advantage with using SQL is to be able to quickly select *one* item
out of millions by use of clever indexes? Here we select *all*
messages and on top of that we sort them?
Grateful for your help, dbmail looks so promising except for the above!
Regards,
/Johan Ekenberg
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________
R.A. Rozendaal
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
www.ic-s.nl
