RolandUnger added a comment.
The Wikivoyage template vCard <https://de.wikivoyage.org/wiki/Modul:VCard> can use up to 50 statements per template (see table ParWD at Module:VCard/Params <https://de.wikivoyage.org/wiki/Modul:VCard/Params>, too). About 5 `addStatementUsage` calls per template on average are not really much even for an entity which is already loaded (loading takes only about 2.5 ms). Within the last weeks we added only //one// statement (P3025 <https://phabricator.wikimedia.org/P3025>: open days). Therefore, the number of `addStatementUsage` calls increased only by a few percent. Some days ago a single `addStatementUsage` call costs // only about 1 ms // but now // 6 ms //. The question arose: why this drastic change: more than 500 %? I have no idea why an access to an entity table already loaded is // now // as much expensive. If we cannot solve this problem then Wikidata will become useless for Wikimedia projects especially for list articles. An optimized Wikidata access for Wikivoyage and other Wikimedia projects is a mission-critical goal. We need the data at Wikidata to easily maintain them for all Wikivoyage projects. The main problem at Wikivoyage is to use data not only in a single information box but at many places in text, too. And why we cannot use this data any longer as we did it within the last four years? When I started to work on a Wikidata usage in vCard template four years ago I was really astonished by the huge computing time: about one minute per article (of course, the parsing was stopped before). That's why I am using a lot of helper tables to // prevent // additional Wikidata access for instance to get labels and country-specific data. TASK DETAIL https://phabricator.wikimedia.org/T265562 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RolandUnger Cc: Lucas_Werkmeister_WMDE, toan, hoo, Lydia_Pintscher, RolandUnger, Aklapper, Akuckartz, Iflorez, darthmon_wmde, alaa_wmde, Nandana, lucamauri, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, LawExplorer, Vali.matei, SundanceRaphael, _jensen, rosalieper, Scott_WUaS, Jonas, Volker_E, alex-mashin, Wikidata-bugs, aude, GWicke, Dinoguy1000, jayvdb, MrStradivarius, Jackmcbarn, Mbch331, Rxy, Jay8g
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
