[Dovecot] SQLite dovecot query caching

[Timo Sirainen]

On Sun, 2012-06-24 at 04:20 +1000, Dominic Malolepszy wrote:
> On 24/06/12 3:39 AM, Timo Sirainen wrote:
> > On Sun, 2012-06-24 at 03:36 +1000, Dominic Malolepszy wrote:
> >> Hi,
> >>
> >> I am wondering if Dovecot caches SQLite queries, and how well it works
> >> in high performance setups. I am particularly interested because in the
> >> below thread SQLite has been suggested as a means of Dovecot proxying
> >> connections to different ports.
> > You can enable auth cache:
> > http://wiki2.dovecot.org/Authentication/Caching
> >
> >
> 
> This is a per user caching though, it will still have to perform a sql 
> look up each time a unique user authenticates to determine what port the 
> proxy should forward each connection. Is that accurate?

It caches the passdb lookup. The cache key consists of the given %
variables in the SQL query. So if your SQL query doesn't contain %n/%u
then the cache doesn't add per-user entries.