Favorite DBMS

[David Relson]

On Sun, 31 Jul 2005 16:17:07 -0300
Thiago Damas wrote:

>   Is SQLite3 the fastest storage backend for bogofilter?

H'lo Thiago,

No.  Berkeley DB is the fastest.  SQLite3 has the advantage of inherent
support of transactions.  To quote from the 0.94.14 announcement:

Why transactions?  Because transactions offer ACID, which stands for
Atomicity, Consistency, Isolation, and Durability, which are key to
transaction processing in databases and ensuring the integrity of a
database.  For more on the subject, see Wikipedia, i.e.
http://en.wikipedia.org/wiki/ACID.  

HTH,

David