Re: [exim] Mail with thousands recipients takes exponential …

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