Am 12.03.21 um 10:21 schrieb Jeremy Harris via Exim-users:
I have a static linear timeframe from one recipient to another
appearing in the log file, once the actual delivery from thunderbird
ended.
strace says, it's due to my SQL select i use. it would go faster if
the SQL result would be cached, instead of repeating itself.
Could you show us the ACL line?
it was a simple one like this:
"select 1 from eximconfig where '${quote_mysql:${domain:$item}}' REGEXP
\Nconcat('^',domain,'$')\N and name='<FIXED KEYWORD>' and value='1' LIMIT 1
As all those 3000 recipients where to the same domain (
test1...test3000@domainname ) it was defacto the same SQL query. I do
not expect a sql cache in exim,
as it would be a very very complex issue and is not really the
bottleneck here.
BTW: Test done on
Name : exim
Version : 4.94
Release : 1.fc32
Architecture: x86_64
best regards,
Marius
--
## 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/
