[exim] Exim and SQL Database performance

Página Principal
Apagar esta mensagem
Responder a esta mensagem
Autor: Robert Blayzor
Data:  
Para: exim-users
Assunto: [exim] Exim and SQL Database performance
When using Exim to pull domainlists, say:

domainlist db_localdoms           = pgsql;....
domainlist db_relaydoms           = pgsql;....
domainlist db_backlisted          = pgsql;....



We use the above referenced domainlists extensively throughout the Exim mail routing and ACL's, etc.

The question is, does Exim execute the SQL query each and every time the domainlist is referenced/used? If so, if you have about 20 routers, etc... that seems like an excessive amount; especially if the domainlist isn't expected to change much for a single email transaction.

If this is the case, is there any recommendations other than not using SQL for domainlists and other data that may be pulled and referenced via the whole mail routing/acceptance process?

--
Robert Blayzor
INOC, LLC
rblayzor@???
http://www.inoc.net/~rblayzor/