Ladsgroup moved this task from Doing to Peer Review on the Wikidata-Campsite
(Wikidata-Campsite-Iteration-∞) board.
Ladsgroup added a comment.
I turned on logging on all of queries to database on my localhost and did
some editing. This is the output for the new term store:
amsa@amsa-Latitude-7480:/var/log/mediawiki$ tail debug-repo.log --lines 200
| grep DBQuery | grep -v LCStoreDB | grep wbt_ | grep -i insert
[DBQuery]
Wikibase\Lib\Store\Sql\Terms\DatabasePropertyTermStore::acquireAndInsertTerms
[0.001s] [Null]: SELECT wbpt_term_in_lang_id AS `value` FROM
`wbt_property_terms` WHERE wbpt_property_id = '21' FOR UPDATE
[DBQuery] Wikimedia\Rdbms\Database::insert [0.001s] [Null]: INSERT INTO
`wbt_text` (wbx_text) VALUES ('fa-value'),('fa-vaeeelue')
[DBQuery] Wikimedia\Rdbms\Database::insert [0s] [Null]: INSERT INTO
`wbt_text_in_lang` (wbxl_text_id,wbxl_language) VALUES ('19','fa'),('18','fa')
[DBQuery] Wikimedia\Rdbms\Database::insert [0s] [Null]: INSERT INTO
`wbt_term_in_lang` (wbtl_text_in_lang_id,wbtl_type_id) VALUES
('19','1'),('18','2')
[DBQuery] Wikibase\Lib\Store\Sql\Terms\{closure} [0s] [Null]: INSERT INTO
`wbt_property_terms` (wbpt_property_id,wbpt_term_in_lang_id) VALUES
('21','18'),('21','19')
Looking at the queries, there's no obvious low-hanging fruit to me. We can
revisit this if we run out of options.
TASK DETAIL
https://phabricator.wikimedia.org/T235117
WORKBOARD
https://phabricator.wikimedia.org/project/board/3539/
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup
Cc: Addshore, Ladsgroup, Aklapper, alaa_wmde, Iflorez, darthmon_wmde,
DannyS712, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer,
_jensen, rosalieper, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
