[Yum-devel] Sqlite performance

[seth vidal]

On Wed, 2007-03-21 at 15:39 +0100, Florian Festi wrote:
> Hi!
> 
> I had the feeling that the yum sqlite db is slow - too slow.
> 
> I wrote a small python program that shows the problem: Joining with packages 
> to map the pkgId to the pkgKey is expensive.
> 
> The values strongly differ depending on the presence of indices (surprise!).
> So my program runs the test twice and tries to create/drop the index. Write 
> access is needed for altering the index.
> 

So anyplace we retrieve pkgIds as a unique identifier it would seem to
make sense to grab pkgKey, too and stuff that in the package object so
we can get to it later for doing joins with it instead of pkgId. Is that
what you were thinking?

-sv