| eranroz added a comment. |
In T151717#3624131, @daniel wrote:In T151717#3623996, @Lydia_Pintscher wrote:I assume the latter also means we are not decreasing the number of irrelevant changes shown in the watchlist and recent changes yet?
Potentially yes. How much impact this actually has is hard to predict. If most pages only use a small fraction of the statements on the items, and a lot of unused statements get added or edited, then the effect is large.
(Although DBA will probably not like this way of estimation) Here is a very rough estimation:
- 1827 statement changes in wikidata since 20/09 should appear in recentchanges
- 33603 is the actual number of statement changes appear
which is 5% relevance...
select substr(rc_comment, locate('[[Property:', rc_comment)+11, locate(']]:', rc_comment)-locate('[[Property:', rc_comment)-11)=substr(wbc_c.eu_aspect,3) AS RC_EU_ATTRIBUTED, count(*) from recentchanges inner join page on rc_namespace=page_namespace and rc_title=page_title inner join wbc_entity_usage wbc_c on eu_page_id=page_id and eu_aspect like 'C%' where rc_source='wb' and rc_comment like '/* wb%claim-create:% */ [[Property:P%' and rc_timestamp>20170920000000 group by substr(rc_comment, locate('[[Property:', rc_comment)+11, locate(']]:', rc_comment)-locate('[[Property:', rc_comment)-11)=substr(wbc_c.eu_aspect,3);
+------------------+----------+
| RC_EU_ATTRIBUTED | count(*) |
+------------------+----------+
| 0 | 1227231 |
| 1 | 1827 |
+------------------+----------+select count(*) from recentchanges where rc_source='wb' and rc_comment like '/* wb%claim-create:% */ [[Property:P%' and rc_timestamp>20170920000000; +----------+ | count(*) | +----------+ | 33603 | +----------+
TASK DETAIL
EMAIL PREFERENCES
To: eranroz
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
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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
