Re: [Exim] speed of lookup types

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Tom
Ημερομηνία:  
Προς: Avleen Vig
Υ/ο: Joshua Alexander, exim-users
Αντικείμενο: 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