Rules via SQL queries?

[ISP List]

At 02:25 PM 10/26/2002 +0100, you wrote:
>What I have been thinking about is a slightly more general system than
>that. You set a parameter to be the name of a Perl function. You write the
>function, which is passed a message and returns a result for that rule.
>Then you can easily write plugins that do things like this. You also write
>an initialisation function that is called at startup for you to setup any
>global state such as database conections.
>
>And you can develop them entirely independent of the MS distribution so
>upgrading is simple.

Question on that.. in exim, if I specify something like this in the config
file:

domainlist relay_to_domains = mysql;SELECT DISTINCT domain from domains
WHERE mx1='mx10.tulsaconnect.com' AND domain='${domain}';

..it executes that sql statement for *every* message that passes through -
it does not just pull the list of domains once and cache it.  In the system
you describe above for MailScanner, does it execute the Rule for each
message that is processed? (I think it does, but I just want to make sure)

--Mike