Re: number of queries in mysql

Gustavo A. Baratto wrote:
> Greetings all,
>
>
> trying to reduce the number of queries on mysql, after reading the docs
> and some other posts, I still have some questions:
>
> 1 - the first query when an e-mail is sent from
> 'server.that.sent.the.msg':
>
> SELECT destination FROM alias WHERE alias='server.that.sent.the.msg'
>
> Why postifx looks for the server that sent out the msg in the virtual
> alias map table? Can this query be avoided at all?

man 5 mysql_table. Postfix allows freeform queries that should
resolve your problems (if i'm wrong, someone mention it).

query = SELECT destination FROM alias WHERE alias='%u@%d'

Cami