[exim] Exim and SQL Database performance

Top Page
Delete this message
Reply to this message
Author: Robert Blayzor
Date:  
To: exim-users
Subject: [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/