[exim] Exim and SQL Database performance

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Robert Blayzor
日付:  
To: exim-users
題目: [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/