Re: [Exim] speed of lookup types

Pàgina inicial
Delete this message
Reply to this message
Autor: Tom
Data:  
A: Avleen Vig
CC: Joshua Alexander, exim-users
Assumpte: 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