Re: [exim] Exim and SQL Database performance

Top Page
Delete this message
Reply to this message
Author: Brent Jones
Date:  
To: Jeremy Harris
CC: exim-users @ exim. org
Subject: Re: [exim] Exim and SQL Database performance
On Fri, Jul 13, 2012 at 12:47 PM, Jeremy Harris <jgh@???> wrote:

> On 2012-07-13 17:18, Robert Blayzor wrote:
>
>> When using Exim to pull domainlists, say:
>>
>> domainlist db_localdoms           = pgsql;....

>>
>
> Run it with suitable debug, and you'll see results being reused from cache.
> It even knows that some SQL ought not to be cached.....
> --
> Jeremy
>
>
>
> --
> ## List details at https://lists.exim.org/**mailman/listinfo/exim-users<https://lists.exim.org/mailman/listinfo/exim-users>
> ## Exim details at http://www.exim.org/
> ## Please use the Wiki with this list - http://wiki.exim.org/
>


The lookup caching is only for that specific Exim process, on each new
message, it must perform the lookups again.
Such lookups are pretty trivial though, unless later down in your config
you perform joins and such.

--
Brent Jones
brent@???