Re: [Exim] speed of lookup types

Top Page
Delete this message
Reply to this message
Author: Tom
Date:  
To: Avleen Vig
CC: Joshua Alexander, exim-users
Subject: Re: [Exim] speed of lookup types
On Sun, 14 Mar 2004, Avleen Vig wrote:

...
> Different expenses. Better to use PostgreSQL (or at least INNODB on
> mysql) which isn't locking.
> You're competing with two problems on flat file DB's:
> Locking
> Linear search speeds

...

A dbm style lookup (BDB) will not lock or require a linear search. dbm
files are indexed. And usually you just rebuild the entire file and
rename it over the old file with exim_dbmbuild, so locking is not an
issue.

Tom