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. http://old.nabble.com/director%3A-non-standart-ports-at-backends-td33991991.html Cheers, Dominic.
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
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?