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