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

2012-08-03 Thread 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,

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

2012-08-02 Thread Roland Rosenfeld
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 someth

[Dovecot] ACL with MySQL dict => full table scans

2012-07-16 Thread Roland Rosenfeld
Hi! I'm just installing ACL support on 2.1.6. When a user changes these ACLs, this results in a full table scan on the dictionary, that tells dovecot who shares with whom. Here's what queries I see when I run $ doveadm acl delete -u user1 shared/user2/folder user=user1 1: SELECT dummy,to_user,