daniel added a comment. @jeroen: the "lookup" may be an exact match, case insensitive, and/or a prefix match. The code that handles these cases for wb_terms is complex and brittle.
Doing this in Cirrus would scale better, because Cirrus supports sharding. We should try to avoid big tables like wb_terms, or at least, avoid queries against them. TASK DETAIL https://phabricator.wikimedia.org/T86530 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign <username>. EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: daniel Cc: thiemowmde, Tobi_WMDE_SW, JeroenDeDauw, JanZerebecki, aude, Aklapper, Liuxinyu970226, daniel, hoo, Wikidata-bugs, GWicke _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
