Re: [Exim] exim's databases and sql

Top Page
Delete this message
Reply to this message
Author: Nico Erfurth
Date:  
To: Avleen Vig
CC: exim-users
Subject: Re: [Exim] exim's databases and sql
Avleen Vig wrote:

> Being able to do multiple reads against the database without having to
> wait for a filesystem lock on the database to be released?


It would be better to extend exim's current databaseusage, to use
specific database features. DB4 and TDB provide fine grained locking (IIRC).

And exim is able to do multiple reads on a database, unless one process
writes :)

For everyone who calls for SQL-hints, think about extra overhead, like
(as Phil already mentioned) process switching, transfer between process
-> kernel -> process, opening the database connection everytime,
authentication, latency and so on.

Btw. I like SQL databases, I use them when they are needed.
But today everyone just things of SQL, when it comes to databases and
wants to use them all the time. (Yeah, sometimes marketing works....)

Nico

--
"Help save the world!"              --Larry Wall in README