thiemowmde added a subscriber: thiemowmde. thiemowmde added a comment. The major problem with both patches is that they use `COUNT` and `JOIN` and `GROUP BY`. This does not scale well for such big tables. What we do now is to store the number of sitelinks per item in a "wb-sitelinks" page property (in the page_props table). `pp_sortkey` is a numeric field that can be accessed then, and possibly ordered (need to check this). This should already be deployed, as far as I know.
So whoever wants to pick this up, please pick one of the existing patches, reopen it and change the SQL query to query pp_sortkey in page_props instead. TASK DETAIL https://phabricator.wikimedia.org/T48217 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: thiemowmde Cc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude, Malyacko _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
