Re: [exim] Tools for SQL export to CDB

Page principale
Supprimer ce message
Répondre à ce message
Auteur: David Saez Padros
Date:  
À: Jeff Garzik
CC: exim users, W B Hacker
Sujet: Re: [exim] Tools for SQL export to CDB
Hi !!

>> we use here a cdb database for white/black listing that is rebuilt every
>> 5 minutes from a mysql database (with more than 4 million ip addresses),
>> in our case the cdb read speed compensates the databse rebuild every 5
>> minutes. Of course this maybe even better using some dbm like database
>> but we don't have tried it yet. For other purposes where data is updated
>> from time to time is even better (username/passwords, etc ...)
>
> I agree cdb is a nice solution, but I would love to see a comparison
> with SQlite.


the problem with sqlite and also with dbm databases is that writing to
the database locks all database (read/write) and only one process can
update the database (only one write lock) and while the database is
being updated no process can read it, so frequent updates make reading
the database slower. As cdb is read only no locking is required.

> Replacing the cdb database every five minutes seems like it would
> destroy the kernel's ability to cache data.


yes, cdb is better when the database needs little updates, someday i
will try to do the same with dbm but i'm not sure it will be faster.

--
Best regards ...

----------------------------------------------------------------
    David Saez Padros                http://www.ols.es
    On-Line Services 2000 S.L.       e-mail  david@???
    Pintor Vayreda 1                 telf    +34 902 50 29 75
    08184 Palau-Solita i Plegamans   movil   +34 670 35 27 53
----------------------------------------------------------------