Last modified: 2014-01-07 09:34:36 UTC
Currently, TermSqlCache::saveTermsOfEntity will detect whether the entity's terms are different from the ones stored in the database for the entity's ID. If there is any change, it will delete all terms for the entity, and re-save all terms. Instead, it would be nice to just delete the terms that were since removed from, and add just the ones that got added to the entity.
Bumping prio - implementing this is pretty simple, and it would reduce database load quite a bit.
bumping some more
Change 99187 had a related patch set uploaded by Daniel Kinzler: (bug 42992) reduce churn on wb_terms table. https://gerrit.wikimedia.org/r/99187
Change 99187 merged by Jeroen De Dauw: (bug 42992) reduce churn on wb_terms table. https://gerrit.wikimedia.org/r/99187