[Dovecot] SQLite dovecot query caching

Dominic Malolepszy dmalolepszy at optusnet.com.au
Sat Jun 23 22:07:48 EEST 2012

On 24/06/12 4:57 AM, Timo Sirainen wrote:
> 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.
Thanks Timo, I re-read the link you sent me, and it makes a lot more 
sense now. I will play around with the different variables (especially 
the port related ones), to get the desired result. Gah its late I should 
go to sleep!

More information about the dovecot mailing list