Sort by Namespace Title
There are a few queries that sort on the namespace title. Since the namespace title isn't indexed this requires a temporary table just for the sort. Also, since you can translate namespace titles, this sort doesn't work as expected anymore.
Because of the complications with translations, this will require a new table (i.e. namespacesort) to fix properly.