On Thu, 21 Dec 2006, seth vidal wrote:
On Thu, 2006-12-21 at 09:49 +0200, Panu Matilainen wrote:

Heh, I forgot about compression completely :) That way things seem a whole
lot better:
1619533 Dec 21 09:17 primary.xml.gz.sqlite.orig.gz
1741906 Dec 21 09:18 primary.xml.gz.sqlite.gz

1223076 Dec 21 09:17 primary.xml.gz.sqlite.orig.bz2
1299333 Dec 21 09:18 primary.xml.gz.sqlite.bz2


yah, that looks a good bit better.

If we changed the filelists db format to be one file per row so we were
storing:

pkgID, full filepath/name

I'm curious how that looks size-wise and what sort of performance we see
out of it with an index on pkgID.

Size-wise it looks pretty bad. So much so that whatever the performance, it's not going to be worth it I think (fc-development filelists used for data):

11905024 filelists.xml.gz.sqlite
37510144 flat/filelists.xml.gz.sqlite

2907828 filelists.xml.gz.sqlite.gz
8301357 flat/filelists.xml.gz.sqlite.gz

        - Panu -

_______________________________________________
Yum-devel mailing list
[email protected]
https://lists.dulug.duke.edu/mailman/listinfo/yum-devel

Reply via email to