[Yum-devel] Sqlite improvements

[Gijs Hollestelle]

On Sun, 23 Jan 2005 13:12:59 +0100, Gijs Hollestelle
<g.hollestelle at gmail.com> wrote:
> There are some outstanding TODOs that need to be addressed before it
> can be added:
> - Support for files.xml.gz (easy)

Just a quick follow up that I have implemented a first version of
filelists.xml now. Only one drawback: its very slow at the moment,
maybe this can be resolved (partialy) by using the same trick that rpm
uses to store file info in its internal database: splitting filenames
up into two different tables: a directory and a filename table and to
join these via a key. I'll try if this speeds things up a bit, if not
maybe we should consider a hybrid aproach that only stores primary
metadata in sqlite and uses general pickles for filelists metadata.

Maybe splitting filenames into file and directory might also be an
idea for the current pickle files, I guess it should reduce their size
drastically (on my machine filelists.xml.gz pickle for fedora-updates
is 31 Megabytes(!))

> The latest version is available from:
> https://svn.win.tue.nl/viewcvs/yum-sqlite/trunk/
It still is :-)

Regards,
  Gijs