[Yum-devel] Sqlite DB Indexes
Florian Festi
ffesti at redhat.com
Thu Aug 2 16:03:41 UTC 2007
Hi!
I did some statistics on how much space the sqlite indexes need. I deleted
the indexes by hand (using sqlite3) and called VACUUM afterwards to shrink
the databases to the really needed size. After that I added all indexes that
I think are useful (which are the current plus the one that can be found
here:
http://devel.linux.duke.edu/gitweb/?p=yum.git;a=commitdiff;h=42283902f929ac131cda7b3497ae047b497e02bc
)
The growth is relative to the files without indexes.
-------------------------------------------------------
| Fedora 7 Everything |
|-----------------------------------------------------|
| | files | primary |files.bz2|primary.bz2|
|No indexes | 34.8 MB | 15.8 MB | 7.2 MB | 3.3 MB |
|Now | 37.2 MB | 20.0 MB | 8.0 MB | 4.9 MB |
|All indexes| 45.5 MB | 25.3 MB | 9.2 MB | 5.5 MB |
|-----------------------------------------------------|
|Growth now | 6.9% | 26.6% | 11.1% | 48.5% |
| Sum | 30.0% | 22.9% |
|Growth all | 30.7% | 60.1% | 27.8% | 66.7% |
| Sum | 40.0% | 40.0% |
-------------------------------------------------------
I attached a small python program that is timing the creation of the
indexes. On my machine it takes exactly 6 seconds. Don't know how this
countervails saving 2.4 (4.2) MB download size.
Any opinions?
BTW: What happened to the delta metadata approach? Is there any code that
should be reviewed? Any help wanted? Project already abandoned?
Florian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqliteindexes.py
Type: text/x-python
Size: 2410 bytes
Desc: not available
Url : http://lists.baseurl.org/pipermail/yum-devel/attachments/20070802/015c926f/attachment.py
More information about the Yum-devel
mailing list