Ladsgroup added a comment.
These are my opinions only, if anyone wants to double check, that'd be great. In T246415#6536970 <https://phabricator.wikimedia.org/T246415#6536970>, @Addshore wrote: > Looking at the ACs I think we have some open questions still > > - How feasible is it to introduce a "client" and "repo" db load group and have it used in the right places in our code? / how could that be tackled. That's not easily feasible as lots of queries come from lib/ data-access/ or core itself (e.g. when looking up entity info using page info lookup) and it's pretty hard to find out what's the context this wiki is being ran. > - How feasible is it to introduce a "terms" db load group and have it used in the right places in our code? / how could that be tackled. This one is pretty easy, since all `->select` calls are contained in terms codebase > - It is possible to do these simultaneously? There are several ways: - Having three groups: `client`, `repo`, `terms`. The first two are complicated but not too much (if we don't want to count the cases involving core) but the third part is easy. The biggest concern would be that if we split the term store reads, there's not much left to split further specially if we don't count queries originating from core, it'll be basically site_per_item reads (for interwiki links) - Having four groups, `client`, `repo`, `repo-terms`, `client-terms`: Not too harder the above but I don't see the point. It wouldn't take advantage of cache locality. TASK DETAIL https://phabricator.wikimedia.org/T246415 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Michael, Ladsgroup Cc: Michael, Marostegui, Ladsgroup, WMDE-leszek, Aklapper, Addshore, Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, darthmon_wmde, Kent7301, alaa_wmde, joker88john, CucyNoiD, Nandana, jijiki, Klaas_Z4us_V, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Pablo-WMDE, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, elukey, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
