[Yum-devel] yum on an olpc machine (slooooooooooow)

[Panu Matilainen]

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 -