-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Rob Church wrote:
On 22/08/07, brion@svn.wikimedia.org brion@svn.wikimedia.org wrote:
Revert r25037 -- just removes functionality from Special:DoubleRedirects instead of fixing the paging problem
I don't agree that this doesn't solve the paging problem; that's exactly what it *does* do. The removal of functionality is an unfortunate side-effect.
The current behaviour caused a large number of individual queries to be executed when the results were cached. If these reports are cached because they are too expensive to run live, then running up to 1000 individual variants of such a query is surely unacceptable?
The extreme slowness which leads to the restriction and caching comes from operating on the entire database at once.
For fetching the current state of a single page, that's a small, quick query. Doing fifty or a hundred of them in a list isn't super-efficient, but it doesn't bring the server to its knees like scanning through an entire table of millions of pages.
One perhaps might be more clever by removing entries from the cached list when they no longer apply (and maybe even re-adding those which become relevant when their state changes).
Note that the report branch I did some work in (which is almost complete; minor bits remaining; could do with some review) solves this issue - when a report is cached, cached rows can be saved with additional arbitrary parameters, which we could use in, e.g. Special:DoubleRedirects to save the other titles.
That's only one part of the problem; marking no-longer-relevant entries is also needed, either by strikeout or removing them or whatever.
- -- brion vibber (brion @ wikimedia.org)