Hi,
the reason for these selects is the possibility that a found
'deliver_to' email address can be a local (dbmail) mail address - so
another select is needed to verify wheter this is true.
If however the found value is numeric a new query is not needed - that
could save us a select.
regards roel
Boyan Alexiev heeft op zaterdag, 22 feb 2003 om 00:39
(Europe/Amsterdam) het volgende geschreven:
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
_______________________________________________
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
