The following bug has been SUBMITTED. ====================================================================== http://dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000125 ====================================================================== Reported By: aaron Assigned To: aaron ====================================================================== Project: DBMail Bug ID: 125 Category: Database layer Reproducibility: always Severity: feature Priority: normal Status: assigned ====================================================================== Date Submitted: 27-Nov-04 12:53 CET Last Modified: 27-Nov-04 12:53 CET ====================================================================== Summary: ACL lookups are terribly inefficient Description: ACL lookups are done with one query per acl type. That means at least a dozen queries for each and every time you read a message or open a mailbox for a summary.
Rewriting the queries and some of the db_acl_* functions to select entire rows of acl's in one query would be much preferred. The temptation is then to cache the ACL values in a bitfield structure. Perhaps not so a bad an idea! ====================================================================== Bug History Date Modified Username Field Change ====================================================================== 27-Nov-04 12:53aaron New Bug ======================================================================
