https://bugzilla.wikimedia.org/show_bug.cgi?id=26311
--- Comment #3 from Roan Kattouw <[email protected]> 2010-12-12 14:15:12 UTC --- (In reply to comment #2) > We are sorting on page_id, because that is an indexed field in the database. > It > could be possible to sort on (page_namespace, page_title) probably as that is > indexed as well. However I don't know what performance consequences that has. > Intuitively I would say that sorting on an int is faster than on a varchar. That's not it. In the case of prop=links, we're sorting by pl_from (which references page_id), then pl_namespace then pl_title. To accomplish the behavior the reporter is asking for, we'd have to sort by (page_namespace, page_title, pl_namespace, pl_title), and sorting on fields spread across multiple tables isn't indexed. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
