random idea for future sqlite-db format changes

seth vidal <[email protected]>
Newsgroups gmane.linux.rpm.metadata
Message-ID <1220634589.17785.68.camel@rosebud>
Create a reference table for requires since they are so often
duplicated.

requires_ref table:
unique key: reqname, flag, ver, pre

then in the requires table you'd have:
pkgkey, requires_ref.unique_key

then instead of the db holding 51K copies of 'libc.so.6' it only stores
one and is referenced over and over again.

Something to work on when we're feeling good about the idea of breaking
the db format version.

-sv


-- 
I only speak for me.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.