| Bawolff added a comment. |
In T151717#3598222, @Halfak wrote:I think the idea is that we'll be able to include wbc_entity_usage to increase granularity in watchlists once this is solved for. It will require some new work though :) Happy to see @Bawolff excited about this functionality.
My understanding is that when someone makes an edit on wikidata, the edit goes into all the recentchanges tables based on if the page is used according to wbc_entity_usage. Due to lack of granuality in wbc_entity_usage, this has caused a spike in the size of the recentchanges table (For example, on romanian wiki, in a 1 week period 98.93% of entries in the recentchanges table were wikidata related (roughly 7000 normal edits vs 1 million wikidata edits). I believe this is overloading the watchlist functionality.
My hope is that by using fine grained tracking on wbc_entity_usage, only when someone edits the actual property in use, will a wikidata edit be propogated to the local recentchanges table, which would significantly reduce the size of that table.
Cc: Bawolff, eranroz, Ottomata, PokestarFan, Ladsgroup, Stashbot, gerritbot, Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, Wikidata-bugs, liangent, jeremyb, aude, Bianjiang, Aklapper, DixonD, daniel, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Marostegui, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
