ViMbAdmin icon indicating copy to clipboard operation
ViMbAdmin copied to clipboard

Database column `mailbox`.`username` is not unique

Open PhrozenByte opened this issue 2 years ago • 0 comments

mailbox.username currently isn't required to be unique in the database (uniqueness is currently only enforced by code), nor is the column even indexed. Querying the ViMbAdmin database using mailbox.username as (supposed to be unique) identifier is one of the main database queries any mail server software (Dovecot, Postfix, etc.) performs frequently (up to thousands of queries a day, depending on the number of users). mailbox.local_part should be indexed, too.

PhrozenByte avatar Jul 13 '22 11:07 PhrozenByte