[Dovecot] ACL with MySQL dict => full table scans (was: v2.1.9 released)

[Timo Sirainen]

On 2.8.2012, at 11.42, Roland Rosenfeld wrote:

> On Wed, 01 Aug 2012, Timo Sirainen wrote:
> 
>> I've again mostly finished reading and answering most of the mails in
>> Dovecot mailing list. There are a couple annoyingly difficult / time
>> consuming bugreport mails that I haven't replied to yet, but if anyone
>> thinks I should have replied to something already feel free to resend
>> the mail.
> 
> I'm not sure where my request was annoying or difficult, but I didn't
> read an answer to it ;-)
> http://www.dovecot.org/list/dovecot/2012-July/067130.html

Yes, it was one of the "annoying" mails. :) The problem is this I think:

http://hg.dovecot.org/dovecot-2.1/file/476381017ec7/src/plugins/acl/acl-backend-vfile-acllist.c#l296

I think it does the rebuild simply because the rebuild code was needed to be written anyway, and doing anything else requires adding more code to handle only the specific necessary additions/removals. A nice side effect of this rebuild is also that it makes sure that the dict is fully up to date even if you had manually changed the dovecot-acl files. But I guess a better solution for that would be a "doveadm acl rebuild" command.

So .. yes, this definitely should be fixed, but it's not really a high priority right now..