Thread:Extension talk:DynamicPageList (Wikimedia)/Code suggestion: Sort by page title w/o specific category/reply

Would be kind of inefficient for larger wikis (but then again, there's a lot of other stuff in this extension that is inefficient). There's no index on page_title (only one on page_namespace, page_title) so that means it would have to filesort [instead of potentially just getting the top x results. In particular in the plain vanilla usage example it would have to sort all pages, instead of getting just the top x pages]. [However, again there is other things in this code that can cause that to. Sorting on page_touched for example].

tl;dr: Some performance concerns, but this extension already has shitty performance. Otherwise looks good. :)