Thread:User talk:MWJames/Search results sorting/reply (2)

There are probably faster ways to gather the same data. For example, the temporary table could be changed into a regular table and updated on a separate schedule. Or it could be replaced with a different kind of join. I need to update some of the larger wikis I am managing to be able to test with enough data.

BTW, why are you merging the two indexes? For me sphinx works just fine when I tell it to use both of them, and merging process needs to load both of them into RAM to merge them, so it is probably slow on a large wiki. What is the benefit for you?