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 -- ## List details at http://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/
