Last modified: 2014-11-20 15:19:15 UTC
On the english wikipedia, the pages Special:DisambiguationPages and Special:DisambiguationPageLinks are not complete (they only give 1000 results!) I want especially point to: http://en.wikipedia.org/w/index.php?title=Special:PagesWithProp/disambiguation gives exactly the same information as http://en.wikipedia.org/w/index.php?title=Special:DisambiguationPages But Special:DisambiguationPages does only give 1000 results and is only cached, while Special:PagesWithProp/disambiguation gives all results and is not cached. This is somehow pointless.
This isn't actually specific to Disambiguator. It's defined by the wgQueryCacheLimit config var. For example, the Redirects list is also limited to 1000 results: http://en.wikipedia.org/wiki/Special:ListRedirects This config var is set to 1000 for enwiki, 2000 for dewiki, and 5000 for all other wikis. So any QueryPages that use caching (i.e. are marked as expensive on a wiki using MiserMode) are limited to X number of results as defined by wgQueryCacheLimit. Unfortunately, this also limits the API results. I'll file a bug about increasing the limit for enwiki.
The other option would be to mark Special:DisambiguationPages as not being expensive. Since it joins the page and page_props tables I imagine it is at least slightly expensive, but it may be worth doing some profiling on it.
Change 73008 had a related patch set uploaded by Kaldari: Optimizing Special:DisambiguationPages query to avoid filesort https://gerrit.wikimedia.org/r/73008
Change 73008 merged by Anomie: Optimizing Special:DisambiguationPages query to avoid filesort https://gerrit.wikimedia.org/r/73008
Ryan Kaldari: This issue has been assigned to you a while ago. Could you please provide a status update and inform us whether you are still working (or still plan to work) on this issue? Only in case you do not plan to work on this issue anymore, should the assignee be set back to default? Thanks.