Re: [Dovecot] SQLite dovecot query caching

2012-07-18 Thread Dominic Malolepszy
On 17/07/12 21:28, Timo Sirainen wrote: The simplest solution would be to just not put username to cache, but I'm worried it might break something else.. So for now I don't think I'm going to change it. Fair enough, last thing I want is you breaking Dovecot, I was just hoping I was doing

Re: [Dovecot] SQLite dovecot query caching

2012-07-17 Thread Timo Sirainen
On 13.7.2012, at 8.30, Dominic Malolepszy wrote: 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. I had a chance to play around with this in the lab. The

Re: [Dovecot] SQLite dovecot query caching

2012-07-12 Thread Dominic Malolepszy
On 24/06/12 04:57, 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

[Dovecot] SQLite dovecot query caching

2012-06-23 Thread Dominic Malolepszy
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.

Re: [Dovecot] SQLite dovecot query caching

2012-06-23 Thread Timo Sirainen
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

Re: [Dovecot] SQLite dovecot query caching

2012-06-23 Thread Dominic Malolepszy
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

Re: [Dovecot] SQLite dovecot query caching

2012-06-23 Thread 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

Re: [Dovecot] SQLite dovecot query caching

2012-06-23 Thread Dominic Malolepszy
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