[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