Le Samedi 23 Avril 2005 14:34, Tobias Rundström a écrit :select p.name from packages p join files f on f.pkgid = p.pkgid where f.filename="/usr/bin/gcc";
It is as slow as the previous query :(
Poor indexes? make sure that you have a index on pkgid in both tables and one filename.
-- Tobias