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
