Autor: Cyborg Datum: To: exim-users Betreff: Re: [exim] Mail with thousands recipients takes exponential longer
time
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
