Re: [Exim] exim's databases and sql

Top Page
Delete this message
Reply to this message
Author: Avleen Vig
Date:  
To: Jerry Jorgenson
CC: exim-users
Subject: Re: [Exim] exim's databases and sql
On Mon, Oct 06, 2003 at 07:39:44AM -0500, Jerry Jorgenson wrote:
> > > You really neem to do tests, where you need to *write* a lot to the
> > > database, to see how the locking effects performance. Reading for the
> > > database can happen concurrently but for fallbacks, or other servers
> > > which queue mail, locking to write will cause a delay.
> > Indeed.
>
> But only if it's writing to the same record, plus the time to create the
> lock, of course.


Depends on your db type. bdb 1.85 will lock the entire file from writes,
in order to write to one row.