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
----------------------------------------------------------------
