[exim] Exim and SQL Database performance

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Robert Blayzor
Dátum:  
Címzett: exim-users
Tárgy: [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/