[Yum-devel] Sqlite performance + tuning

[Florian Festi]

> If you have some example code to make the indexes on the fly I'll give
> it a run on the XO and see how bad it really ends up being.

Just execute the following SQL statements (terminate with ";" when in the 
sqlite3 shell)

CREATE INDEX IF NOT EXISTS pkgprovides ON provides (pkgKey)
CREATE INDEX IF NOT EXISTS pkgrequires ON requires (pkgKey)
CREATE INDEX IF NOT EXISTS pkgconflicts ON conflicts (pkgKey)
CREATE INDEX IF NOT EXISTS pkgobsoletes ON obsoletes (pkgKey)

Florian