Brion Vibber wrote:
Actually, Related Changes is more like Watchlist than
it is like
Recent Changes, and when you dump a couple thousand links to Related
Changes, it's pretty slow too.
Both Related Changes and the Watchlist have the same problem: they
have a long list of pages sorted by ID or title, but need to report
them sorted by timestamp. This requires fetching a couple thousand
rows and sorting every single one before returning the last N edits.
As an example, it takes 10 seconds or so to return Related Changes on
a copy of my watchlist:
http://www.wikipedia.org/wiki/Special:Recentchangeslinked/User:Brion_VIBBER…
I might be stating the obvious here...
but each time I look at my watchlist, only a dozen or so pages have
moved to the top.
So you could discard everything that is older than the last view, or
maybe the last day / week (user option?)
Or would this method be better:
1. grab stored version watchlist (already ordered)
2. get date of last view of watchlist
3. examine the RC list from that date on
4. pick out items from that list that exist on the watchlist