I have filed an RFC about ways to improve the performance of the wb_terms table
(or rather, how to replace it with something that works better).
https://phabricator.wikimedia.org/T86530
--
Daniel Kinzler
Senior Software Developer
Wikimedia Deutschland
Gesellschaft zur Förderung Freien Wissens e.V.