Hi, Cyborg <[email protected]> (Mo 04 Jul 2016 11:08:23 CEST): > Hi, > > does anyone see a way to optimize one condition away without changing > the SQL ? > > condition = ${if !eq{TXTA}{${lookup mysql {SELECT --SQL-- }}} {1}} > condition = ${if !eq{TXTB}{${lookup mysql {SELECT --SQL-- }}} {1}}
Exim caches the last lookup and reuses it if it looks the same.
But *any* lookup that is not identical to the lookup done before
invalidates the cache.
> set acl_m9 = ${lookup mysql {SELECT --SQL-- }}
> condition = ${if !eq{TXTA}{$acl_m9} {1}}
> condition = ${if !eq{TXTB}{$acl_m9} {1}}
Yes, should work.
> Also an option would be something like this : any REGEX available at
> that point?
>
> condition = ${if !Regexp{(TXTA|TXTB)}{ SQL } {1}}
Check for the "match" condition.
condition = ${if match{ SQL }{TXT(A|B)}}
Best regards from Dresden/Germany
Viele Grüße aus Dresden
Heiko Schlittermann
--
SCHLITTERMANN.de ---------------------------- internet & unix support -
Heiko Schlittermann, Dipl.-Ing. (TU) - {fon,fax}: +49.351.802998{1,3} -
gnupg encrypted messages are welcome --------------- key ID: F69376CE -
! key id 7CBF764A and 972EAC9F are revoked since 2015-01 ------------ -
signature.asc
Description: Digital signature
-- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
