Re: [exim] Exim with SQL message store

Marten Lehmann wrote:
> Hi,
>
>> I'd go for the other option: keep the existing logging, and *also* copy
>> it into a database, and then query that database. This could be
>> real-time (by extending your syslog) or near-real-time (by having
>> log-file watchers), or batched in cron every n minutes ...
>
> I was not asking for logging. SQL-logging might be nice as well, but it
> is more important, that all queue relevent need to be stored in a sql
> database. This would improve performance a lot. Right now exim has to
> parse thousands of files for find out which is the next one for a
> delivery attempt. A sql database which a fixed column set would be much
> simpler and the real message wouldn't have to be stored as blob, it
> could still be stored as a textfile.
>
> Wouldn't this be a goal for exim in general to improve the meta-data in
> queue data in a structured storage like SQLite?
>
> Regards
> Marten
>

BTW - See DBmail and PowerMail (the F/OSS MTA not the Swiss for-fee MUA)

I've run both.

I switched to Exim.

Lest we forget, the UFS FS (and derivatives) *is* a DB of sorts.

So the SQL cure was more costly than the alleged fs-based 'disease'.

And more fragile.

'nuf said...

Bill