Addshore added a comment.
If elastic already has captions indexed then yes this could probably just use elastic. (There would be slightly more delay and potential unpredictability using elastic than some mysql tables like wb_terms). However I would be wary, as we have before discussed using elastic for similar lookups for item labels, and there was worry about the scale and increased traffic it would cause on elastic. I know media info isn't there yet in terms of these caption to entity lookups, but it will continue to increase, and there is no reason it couldn't even surpass the rate of the requests of this type for items. TASK DETAIL https://phabricator.wikimedia.org/T227847 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Smalyshev, Abit, jcrespo, alaa_wmde, hoo, Addshore, Ladsgroup, Lucas_Werkmeister_WMDE, Jarekt, Aklapper, Cparle, Mike_Peel, Jheald, Keegan, Marsupium, Multichill, matthiasmullie, JKSTNK, Lahi, PDrouin-WMF, E1presidente, Ramsey-WMF, Anooprao, SandraF_WMF, Tramullas, Acer, V4switch, Salgo60, Silverfish, Susannaanas, Wong128hk, Jane023, Wikidata-bugs, Base, Ricordisamoa, Wesalius, Lydia_Pintscher, Fabrice_Florin, Raymond, Jdforrester-WMF, Steinsplitter, Matanya
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs