API: Allow page_id sort order for list=allpages
Open, LowPublic

Description

list=allpages gives pages in order of titles to the given namespace. It should also be possible to get the pages in page_id order.

This allows getting newer pages easier as with Special:NewPages/list=recentchanges and over the 30 days.

Maybe add a apsort=title|pageid param
Having the apnamspace param still working would be nice.


Version: 1.24rc
Severity: enhancement

Details

Reference
bz68428
bzimport raised the priority of this task from to Low.
bzimport set Reference to bz68428.
bzimport added a subscriber: Unknown Object (MLST).

While this looks easy, anyone attempting this should be sure they are familiar with MySQL query optimization. The query is currently along the lines of "SELECT ... FROM page WHERE page_namespace = '0' ORDER BY page_title", using the name_title index on the page table. Be sure your new query is still indexed and is not filesorting.