Lucas_Werkmeister_WMDE added a comment.
Yeah, that’s what I meant with this part of the task description: > However, the current interfaces for the new term store would only allow us to get all the term IDs for properties (effectively the entire content of `wbt_property_terms`), then resolve all those terms to a giant array, and then filter for labels in a certain language afterwards. We can’t afford to transfer all that data between PHP and the database, **so instead the `wbt_property_terms` and `wbt_term_in_lang` parts will have to exchange JOIN conditions somehow**, so that we can load all property labels in a certain language with just one query. (It still won’t be as efficient as in `wb_terms`, but with caching it should do for a while, and we can investigate improvements later.) I was thinking of something like `ActorMigration::getJoin()` or `CommentStore::getJoin()`, so you can still keep the components //somewhat// separate. TASK DETAIL https://phabricator.wikimedia.org/T225003 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: hoo, Lucas_Werkmeister_WMDE Cc: alaa_wmde, Aklapper, Lucas_Werkmeister_WMDE, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, darthmon_wmde, joker88john, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
