I am looking for a way to optimize/limit the number of queries that need to be
executed to the database server for single email transactions. Currently there
are several different individual queries that lookup homedir, auto responder,
user forward, quota, etc.
These can all be done with a single SQL query using multiple columns and
assuming taking advantage of Exim's built in lookup caching.
Per the Exim doc:
-8<---
If the result of the query contains more than one field, the data for each
field in the row is returned, preceded by its name, so the result of
${lookup pgsql{select home,name from users where id='foobar'}{$value}}
might be
home=/home/foobar name="User Foo"
-8<---
That said, is there a build in function in Exim that allows you to grab those
multiple elements out of the string without having to create some crazy regex
match to get the fields your looking for on each one?
ie: does something like this work or make sense?
${lookup pgsql{select home,name from users where id='foobar'}{$value:home}}
--
Robert Blayzor
INOC, LLC
[email protected]
http://www.inoc.net/~rblayzor/
--
## 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/
