[Wikidata-bugs] [Maniphest] [Created] T204109: Investigate some Wikdata write api queries taking over 30 seconds. (In EntityContent::collectValues ?)

[Addshore]

Addshore created this task. Addshore added projects: Wikidata, Performance, wikidata-tech-focus. Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION

While investigating T97368#4576389 I noticed that the particular query that I was looking at took over 30 seconds to finish executing according to the api.log

... [W5jEGwpAAK4AAKd9eigAAAAV] ... API POST ... T=31327ms action="" format=json claim=Q56596767$BD081022-A6F4-4297-B7A2-484F2918094A property=P1932 value=%22A.%20Zucchetta%22 snaktype=value ... baserevid=744943483 bot=1

I recreated the edit to profile and the result can be seen on https://performance.wikimedia.org/xhgui/run/view?id=5b98dd85bb85446306a75aae

This appears to indicate that most of the time is spent in a single method in EntityContent:

Wikibase\EntityContent::collectValues@2
3,530,113 µs

Which is apparently called 30 times?

I might need someone from #performance-team, perhaps @Krinkle to make sure I am reading xhgui correctly

We should investigate this and see if we can speed this code path up.

It would be great to create a copy of this item on our test wiki to benchmark against.

TASK DETAIL

https://phabricator.wikimedia.org/T204109

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Addshore
Cc: Addshore, Krinkle, Aklapper, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, LawExplorer, Vali.matei, Volker_E, Wikidata-bugs, aude, GWicke, Dinoguy1000, Mbch331, Jay8g

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs