https://bugzilla.wikimedia.org/show_bug.cgi?id=34568

--- Comment #3 from Aaron Schulz <[email protected]> 2012-06-28 18:44:31 
UTC ---
PendingChanges uses either the flaggedpages table (pending items are indexed)
or the flaggedpages_pending (which is a denormalization) tables. Both of which
work well for this purpose, and don't require scanning massive portions of the
page table. The number of pending pages tends to be from zero to a few
dozen-thousand. Filtering by namespaces is thus easy.

The only way to do this well is to page on page_id rather than page_title. It
would be confusing to page differently based on whether an namespace is
provided, so we would have to always page by page_id, which would be slower if
I specify a namespace that's only gets a small portion of edits.

UnreviewedPages is really only useful for getting really old pages that still
haven't been reviewed. It seems like NewPages would be more useful (filtered
for unpatrolled). Maybe that can have a category selector?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to