Re: [Exim] MySQL persistant?

On Fri, Mar 26, 2004 at 02:06:18PM +0100, Daniel Tiefnig said:
> Philip Hazel wrote:
> >>Well, I'd like to note, that I'd love to see exim caching a few
> >>more MySQL queries/results, as just one single query cache is to
> >>less in many setups. Anyone into making the cache an array instead
> >>of a simple scalar?
> >
> >Given Exim's short-lived process model, I don't think that you would
> >gain too much by doing that.
<snip>
> >There was a suggestion of writing a permanently-running "database
> >query and caching engine" which could be accessed via a socket.
>
> I'm not sure whether this would give much improvement compared to a
> MySQL engine accesed via a local socket. Might be much work for
> relatively less benefit... (It may be a good idea for setups with remote
> DB Servers, though.)

Keep in mind that MySQL has internal caching that can be enabled and
tweaked quite a bit. If your box has ample memory, you can get pretty
decent performance increases by giving MySQL more memory to work with.