Hi again, this is the debug info for these selects:
dbmail/smtp[23681]: auth_check_user(): into checking loop dbmail/smtp[23681]: auth_check_user(): checking user [EMAIL PROTECTED] to 3 dbmail/smtp[23681]: auth_check_user(): checking user [3] in alias table dbmail/smtp[23681]: auth_check_user(): executing query, checks [1] dbmail/smtp[23681]: __auth_query(): executing query [SELECT deliver_to FROM aliases WHERE alias="3"] dbmail/smtp[23681]: auth_check_user(): adding [3] to deliver_to address dbmail/smtp[23681]: insert_messages(): user [EMAIL PROTECTED] found total of [1] aliases dbmail/smtp[23681]: insert_messages(): alias deliver_to is [3] Could this be optimized? Best regards, Bobby [EMAIL PROTECTED] on Saturday, February 22, 2003, 1:17:08 AM, Boyan Alexiev wrote: BA> Hello! BA> I have noticed that dbmail makes 2 sequential selects for the same BA> message: BA> 19693 Query SELECT deliver_to FROM aliases WHERE alias="[EMAIL PROTECTED]" BA> 19693 Query SELECT deliver_to FROM aliases WHERE alias="3" BA> In this case "3" is the owner_id of the user and also the BA> mailbox_idnr. Is this normal or is it an unnecessary operation? BA> Best regards, BA> Bobby BA> [EMAIL PROTECTED] BA> _______________________________________________ BA> Dbmail mailing list BA> Dbmail@dbmail.org BA> https://mailman.fastxs.nl/mailman/listinfo/dbmail
