Re: AW: Postfix + MySql - reducing queries?

At 18:46 04/02/2004, you wrote:
>Hi,
> > With MySQL 4.0.1, you may use query cache (see mysql server manual)
>ok thnx ...
>but i am still confused about why
>e.g. the cleanup service lockups things that
>have already been discovered by smtpd?
>
>e.g.:
>----------------------
>[SMTPD]
>3490 Query select goto from alias where address = 'user@mydomain'
>3490 Query select goto from alias where address = '@mydomain'
>3491 Query select maildir from mailbox where address = 'user@mydomain'
>[pre clenaup ?!]
>3490 Query select goto from alias where address = 'user@mydomain'
>3490 Query select goto from alias where address = '@mydomain'
>3491 Query select maildir from mailbox where address = 'user@mydomain'
>----------------------

Wietse will it out much more precisely than i do, but it is all related to
Postfix not being a monolithic system ( as opposed to Sendmail, for example
); It is this "modularity" which makes it *secure*: privilege separation +
simple code, easier to audit.

- If you need to reduce the number of queries(performance reasons), use the
query cache
- If you need to reduce the number of connections( limit on number of
threads available ), use the 'proxymap' mechanism

>Regards,
> niko

J.L.