{"action":"created","issue":{"url":"https://api.github.com/repos/Wikidata/editgroups/issues/14","repository_url":"https://api.github.com/repos/Wikidata/editgroups","labels_url":"https://api.github.com/repos/Wikidata/editgroups/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/Wikidata/editgroups/issues/14/comments","events_url":"https://api.github.com/repos/Wikidata/editgroups/issues/14/events","html_url":"https://github.com/Wikidata/editgroups/issues/14","id":377151111,"node_id":"MDU6SXNzdWUzNzcxNTExMTE=","number":14,"title":"Precompute number of entities edited during ingestion","user":{"login":"wetneb","id":309908,"node_id":"MDQ6VXNlcjMwOTkwOA==","avatar_url":"https://avatars1.githubusercontent.com/u/309908?v=4","gravatar_id":"","url":"https://api.github.com/users/wetneb","html_url":"https://github.com/wetneb","followers_url":"https://api.github.com/users/wetneb/followers","following_url":"https://api.github.com/users/wetneb/following{/other_user}","gists_url":"https://api.github.com/users/wetneb/gists{/gist_id}","starred_url":"https://api.github.com/users/wetneb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wetneb/subscriptions","organizations_url":"https://api.github.com/users/wetneb/orgs","repos_url":"https://api.github.com/users/wetneb/repos","events_url":"https://api.github.com/users/wetneb/events{/privacy}","received_events_url":"https://api.github.com/users/wetneb/received_events","type":"User","site_admin":false},"labels":[{"id":1115602381,"node_id":"MDU6TGFiZWwxMTE1NjAyMzgx","url":"https://api.github.com/repos/Wikidata/editgroups/labels/performance","name":"performance","color":"bfdadc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-04T13:09:46Z","updated_at":"2018-11-04T18:33:08Z","closed_at":null,"author_association":"MEMBER","body":"Currently we run this query for every batch page:\r\n\r\n```\r\nCOUNT(*) FROM (SELECT DISTINCT `store_edit`.`title` AS Col1 FROM `store_edit` WHERE `store_edit`.`batch_id` = 37122)\r\n````\r\n\r\nThis is very expensive for large edit groups.\r\nWe should instead maintain a count of entities edited, just like we cache the edit count. It is slightly more expensive to maintain as we need to match the ingested edits to the existing ones but we already have an index for that anyway."},"comment":{"url":"https://api.github.com/repos/Wikidata/editgroups/issues/comments/435694098","html_url":"https://github.com/Wikidata/editgroups/issues/14#issuecomment-435694098","issue_url":"https://api.github.com/repos/Wikidata/editgroups/issues/14","id":435694098,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNTY5NDA5OA==","user":{"login":"wetneb","id":309908,"node_id":"MDQ6VXNlcjMwOTkwOA==","avatar_url":"https://avatars1.githubusercontent.com/u/309908?v=4","gravatar_id":"","url":"https://api.github.com/users/wetneb","html_url":"https://github.com/wetneb","followers_url":"https://api.github.com/users/wetneb/followers","following_url":"https://api.github.com/users/wetneb/following{/other_user}","gists_url":"https://api.github.com/users/wetneb/gists{/gist_id}","starred_url":"https://api.github.com/users/wetneb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wetneb/subscriptions","organizations_url":"https://api.github.com/users/wetneb/orgs","repos_url":"https://api.github.com/users/wetneb/repos","events_url":"https://api.github.com/users/wetneb/events{/privacy}","received_events_url":"https://api.github.com/users/wetneb/received_events","type":"User","site_admin":false},"created_at":"2018-11-04T18:33:08Z","updated_at":"2018-11-04T18:33:08Z","author_association":"MEMBER","body":"We might need to do this for reverts and item creations too. Groups like https://tools.wmflabs.org/editgroups/b/QSv2T/1541227030033/ still take a while to load."}}
{"actor":{"display_login":"wetneb"}}