[packagekit] yum: being naughty with SQL

[Richard Hughes]

Today I spend a bit of time profiling yum and PackageKit to see why
things take so long to select different groups in gpk-application.

The old:

[hughsie at hughsie-work helpers]$ time ./search-group.py none games
real	0m14.899s
user	0m14.520s
sys	0m0.277s

The new:

[hughsie at hughsie-work helpers]$ time ./search-group.py none games
real	0m1.050s
user	0m0.867s
sys	0m0.114s

See https://bugzilla.redhat.com/show_bug.cgi?id=453356 for all the gory
details. It basically involves accessing the yum database directly using
sqlite, rather than using yum itself. Patch attached for review,
comments welcome.

I know accessing the database without using yum is bad, but we are only
reading it rather than changing anything. Yell if you have reservations
about doing this, or anything else we can try.

Richard.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: packagekit-yum-sqlite.patch
Type: text/x-patch
Size: 7866 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/packagekit/attachments/20080702/803fa947/attachment-0004.bin>