|Resolved||• Addshore||T188992 Make wb_terms table fancy|
|Resolved||Lucas_Werkmeister_WMDE||T188993 Replace term_search_key and term_weight with empty values when wb_terms is not used for search|
|Declined||Ladsgroup||T189779 Run clearTermSqlIndexSearchFields on Wikidata|
|Resolved||Lucas_Werkmeister_WMDE||T191631 Add maintenance script to wipe term_search_key and term_weight columns|
rebuildTermSqlIndex.php is probably a lot more expensive than we need – to clear the term_search_key and term_weight columns, we shouldn’t need to load and parse entities. So perhaps some new, small maintenance script that just writes empty values to that column would be better.
I’m not sure… to clear term_search_key and term_weight, I think it would make sense to iterate over the term_row_id, right? Whereas I assume rebuildTermSqlIndex iterates over entity IDs and then sets all term rows for that entity ID.