Re: Sqlite performance + tuning

> 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
_______________________________________________
Yum-devel mailing list
Yum-devellinux.duke.edu
https://lists.dulug.duke.edu/mailman/listinfo/yum-devel