Call for testing new expiration and ovsqlite features

[Julien ÉLIE]

Hi Jesse, and all,

>>> I'm very excited about these changes, hats off to everyone involved!
> 
> Do you happen to have found a bit of time to test these new features?
> 
> In addition, Kevin contributed a few days ago a new SQLite-based history 
> method:
>    https://github.com/InterNetNews/inn/pull/349
> 
> It would be worthwhile testing too, notably to see whether it performs 
> better on large spools.  If you are disposed to give it a try in a 
> testing instance, you can apply the patch (or I can generate a tarball 
> with the patch for you).

The new history storage method using SQLite is available in latest 
snapshots.  You may want to try it :)

See the hissqlite-convert manual page to convert a hisv6 database to 
hissqlite.
Basically, assuming pathdb is /news/db:
1 - Stop INN.
2 - Update to the latest CURRENT version.
3 - Run: hissqlite-convert /news/db/history /news/db/history
4 - If it went fine (history.sqlite generated, and no errors during the 
conversion), change hismethod to hissqlite in inn.conf.
5 - Start INN.
6 - Enjoy!



Also, did you try the improvements to expire/expireover?

-- 
Julien ÉLIE

« Hâte-toi de bien vivre et songe que chaque jour est à lui seul une
   vie. » (Sénèque)