{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/7641","labels_url":"https://api.github.com/repos/piwik/piwik/issues/7641/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/7641/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/7641/events","html_url":"https://github.com/piwik/piwik/pull/7641","id":67022738,"number":7641,"title":"Faster access loading - Make dashboard etc faster when having thousands of sites","user":{"login":"tsteur","id":273120,"avatar_url":"https://avatars.githubusercontent.com/u/273120?v=3","gravatar_id":"","url":"https://api.github.com/users/tsteur","html_url":"https://github.com/tsteur","followers_url":"https://api.github.com/users/tsteur/followers","following_url":"https://api.github.com/users/tsteur/following{/other_user}","gists_url":"https://api.github.com/users/tsteur/gists{/gist_id}","starred_url":"https://api.github.com/users/tsteur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tsteur/subscriptions","organizations_url":"https://api.github.com/users/tsteur/orgs","repos_url":"https://api.github.com/users/tsteur/repos","events_url":"https://api.github.com/users/tsteur/events{/privacy}","received_events_url":"https://api.github.com/users/tsteur/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/piwik/piwik/labels/c:%20Performance","name":"c: Performance","color":"ededed"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/76","html_url":"https://github.com/piwik/piwik/milestones/Piwik%202.13.0","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/76/labels","id":969583,"number":76,"title":"Piwik 2.13.0","description":"Pool of tickets we pick issues to work on. This release may include DB schema upgrades.\r\n","creator":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"open_issues":18,"closed_issues":88,"state":"open","created_at":"2015-02-07T01:34:22Z","updated_at":"2015-04-17T04:11:26Z","due_on":"2015-04-21T12:00:00Z","closed_at":null},"comments":2,"created_at":"2015-04-08T00:55:42Z","updated_at":"2015-04-17T04:14:42Z","closed_at":"2015-04-17T02:45:59Z","pull_request":{"url":"https://api.github.com/repos/piwik/piwik/pulls/7641","html_url":"https://github.com/piwik/piwik/pull/7641","diff_url":"https://github.com/piwik/piwik/pull/7641.diff","patch_url":"https://github.com/piwik/piwik/pull/7641.patch"},"body":"Currently, we do always load the sites a user has access to even though when never requested. Eg most dashboard widgets do not need to fetch all siteIds from the database when someone is a superuser. When someone is a user we still often need to do it but often users maybe do not have access to eg all 50k sites so it should be fast.\r\n\r\nBasically we want to lazy load the sites a user has access to. This improves performance quite a bit especially when opening the dashboard and when many requests to request 50k sites in parallel. On a fast server the difference is not that obvious but one can feel it is faster."},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/93889692","html_url":"https://github.com/piwik/piwik/pull/7641#issuecomment-93889692","issue_url":"https://api.github.com/repos/piwik/piwik/issues/7641","id":93889692,"user":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"created_at":"2015-04-17T04:14:42Z","updated_at":"2015-04-17T04:14:42Z","body":"fyi: the build was broken at this commit: https://travis-ci.org/piwik/piwik/jobs/58851183 "}}