Tr: kudos to ovdb + compression

[Julien ÉLIE]

Hi,

An interesting feedback from Michael Grimm on news.software.nntp.
ovdb + zlib reduces by a factor of 60% the time spent by expireover.

Julien

----- Message d'origine ----- 
De : "Michael Grimm" <trashcan at odo.in-berlin.de>
Groupes de discussion : news.software.nntp
Envoyé : samedi 28 novembre 2009 15:19
Objet : kudos to ovdb + compression


> Hi --
>
> JFTR: I finally upgraded my reader from 2.4.6 to 2.5.1 and rebuilt the
> old ovdb overview database using the new compression functionality:
>
> 2.4.6 + ovdb (db47):
>
> 18,500,000 articles in spool
> 21 GB size overview database
> 5:45 hours for expireover
>
> 2.5.1 + ovdb (db47) + compression:
>
> 18,500,000 articles in spool
> 16,5 GB size overview database
> 2:20 hours for expireover
>
> Well, many kudos to those involved! That is great, especially the
> improvement in expireover runtime.
>
> Heath Kehoe's findings were similar, a couple of years ago:
> ,----[ https://lists.isc.org/pipermail/inn-workers/2004-June/013106.html ]-
> | On my server with about 21 million overview records, after
> | rebuilding the databases with compression enabled, the overview
> | directory went from around 20 GB to 12.6 GB, and the expireover
> | run went from 6 hours to 2 hours.
> `----
>
> Regards and I'm very pleased,
> Michael
> -- 
> to let