On ĵaŭ, 2002-05-09 at 17:12, Jimmy Wales wrote:

I just now made the function look like this:

function getOtherNamespaces () {
    $a = array () ;
    # modification by Jimbo
    return $a;

I assume that forces it to return an empty array and not run the rest of the code.

The site didn't die, so I'll assume that's o.k. as an emergency measure.

As Chuck has noted, this has the effect of removing all the Talk links!

I suspect the problem may be this query: SELECT cur_title FROM cur WHERE cur_title LIKE "%:$n"

I put a similar query into the Watchlist code so that watchlisting a title would list updates to pages with that title in all namespaces (mainly for talk pages), and it slowed to a completely unusable crawl: my (more than ample) watchlist eventually times out before giving any output. (Note that I've already put a workaround for that into CVS to explicitly look for talk pages.)

It may be useful to split the title into separate namespace and (sub)title fields so that slow substring matches don't need to be used. Alternatively, a more efficient way to search the existing field this way would be welcome.

I've attached a patch for a workaround that replaces the query with just the talk page link; give it a try and see if that's still helping.

-- brion vibber (brion @ pobox.com)