{"action":"created","issue":{"url":"https://api.github.com/repos/Wikia/app/issues/9323","labels_url":"https://api.github.com/repos/Wikia/app/issues/9323/labels{/name}","comments_url":"https://api.github.com/repos/Wikia/app/issues/9323/comments","events_url":"https://api.github.com/repos/Wikia/app/issues/9323/events","html_url":"https://github.com/Wikia/app/pull/9323","id":122483855,"number":9323,"title":"Add caching around CategoryDataService::getArticleCount","user":{"login":"macbre","id":1929317,"avatar_url":"https://avatars.githubusercontent.com/u/1929317?v=3","gravatar_id":"","url":"https://api.github.com/users/macbre","html_url":"https://github.com/macbre","followers_url":"https://api.github.com/users/macbre/followers","following_url":"https://api.github.com/users/macbre/following{/other_user}","gists_url":"https://api.github.com/users/macbre/gists{/gist_id}","starred_url":"https://api.github.com/users/macbre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/macbre/subscriptions","organizations_url":"https://api.github.com/users/macbre/orgs","repos_url":"https://api.github.com/users/macbre/repos","events_url":"https://api.github.com/users/macbre/events{/privacy}","received_events_url":"https://api.github.com/users/macbre/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-16T11:31:39Z","updated_at":"2015-12-16T11:39:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Wikia/app/pulls/9323","html_url":"https://github.com/Wikia/app/pull/9323","diff_url":"https://github.com/Wikia/app/pull/9323.diff","patch_url":"https://github.com/Wikia/app/pull/9323.patch"},"body":"[PLATFORM-1192](https://wikia-inc.atlassian.net/browse/PLATFORM-1192)\r\n\r\nIt hits the database heavily as it's executed for the same category over and over again when processing offline tasks (with some queries reaching 45 seconds of execution time and an average at ~6 seconds).\r\n\r\n@wladekb / @pchojnacki / @frankfarmer "},"comment":{"url":"https://api.github.com/repos/Wikia/app/issues/comments/165077993","html_url":"https://github.com/Wikia/app/pull/9323#issuecomment-165077993","issue_url":"https://api.github.com/repos/Wikia/app/issues/9323","id":165077993,"user":{"login":"wladekb","id":811686,"avatar_url":"https://avatars.githubusercontent.com/u/811686?v=3","gravatar_id":"","url":"https://api.github.com/users/wladekb","html_url":"https://github.com/wladekb","followers_url":"https://api.github.com/users/wladekb/followers","following_url":"https://api.github.com/users/wladekb/following{/other_user}","gists_url":"https://api.github.com/users/wladekb/gists{/gist_id}","starred_url":"https://api.github.com/users/wladekb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wladekb/subscriptions","organizations_url":"https://api.github.com/users/wladekb/orgs","repos_url":"https://api.github.com/users/wladekb/repos","events_url":"https://api.github.com/users/wladekb/events{/privacy}","received_events_url":"https://api.github.com/users/wladekb/received_events","type":"User","site_admin":false},"created_at":"2015-12-16T11:39:17Z","updated_at":"2015-12-16T11:39:17Z","body":"lgtm,\r\n\r\nI'd just double check all the places where this method is used and verify that receiving a possibly inaccurate count doesn't break anything."}}