{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/7410","repository_url":"https://api.github.com/repos/CartoDB/cartodb","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/7410/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/7410/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/7410/events","html_url":"https://github.com/CartoDB/cartodb/issues/7410","id":155289825,"number":7410,"title":"Dashboard requests mapviews for all maps in an organization while loading public view","user":{"login":"zenitraM","id":863975,"avatar_url":"https://avatars.githubusercontent.com/u/863975?v=3","gravatar_id":"","url":"https://api.github.com/users/zenitraM","html_url":"https://github.com/zenitraM","followers_url":"https://api.github.com/users/zenitraM/followers","following_url":"https://api.github.com/users/zenitraM/following{/other_user}","gists_url":"https://api.github.com/users/zenitraM/gists{/gist_id}","starred_url":"https://api.github.com/users/zenitraM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zenitraM/subscriptions","organizations_url":"https://api.github.com/users/zenitraM/orgs","repos_url":"https://api.github.com/users/zenitraM/repos","events_url":"https://api.github.com/users/zenitraM/events{/privacy}","received_events_url":"https://api.github.com/users/zenitraM/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/backend","name":"backend","color":"d4c5f9"},{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/Editor","name":"Editor","color":"006b75"}],"state":"open","locked":false,"assignee":{"login":"javitonino","id":7569673,"avatar_url":"https://avatars.githubusercontent.com/u/7569673?v=3","gravatar_id":"","url":"https://api.github.com/users/javitonino","html_url":"https://github.com/javitonino","followers_url":"https://api.github.com/users/javitonino/followers","following_url":"https://api.github.com/users/javitonino/following{/other_user}","gists_url":"https://api.github.com/users/javitonino/gists{/gist_id}","starred_url":"https://api.github.com/users/javitonino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javitonino/subscriptions","organizations_url":"https://api.github.com/users/javitonino/orgs","repos_url":"https://api.github.com/users/javitonino/repos","events_url":"https://api.github.com/users/javitonino/events{/privacy}","received_events_url":"https://api.github.com/users/javitonino/received_events","type":"User","site_admin":false},"milestone":null,"comments":6,"created_at":"2016-05-17T15:30:01Z","updated_at":"2016-05-23T12:15:46Z","closed_at":null,"body":"Steps to reproduce:\r\n\r\n- View an organization public page with a lot of users and a lot of visualizations -> takes a long time\r\n- See `redis-cli monitor` meanwhile\r\n\r\nIt seems that it is loading mapviews for all visualizations of all users to render the page. It is also doing four `ZSCANs` per user which according to @luisbosque it should not be doing:\r\n\r\n```\r\n1463498750.816189 [5 10.0.130.4:38613] \"zscan\" \"user:[USER]:mapviews:stat_tag:[VIZ_ID]\" \"0\" \"MATCH\" \"201604*\"\r\n1463498750.816825 [5 10.0.130.4:38613] \"zscan\" \"user:[USER]:mapviews:stat_tag:[VIZ_ID]\" \"0\" \"MATCH\" \"201605*\"\r\n1463498750.817808 [5 10.0.130.4:38613] \"zscan\" \"user:[USER]:mapviews_es:stat_tag:[VIZ_ID]\" \"0\" \"MATCH\" \"201604*\"\r\n1463498750.818642 [5 10.0.130.4:38613] \"zscan\" \"user:[USER]:mapviews_es:stat_tag:[VIZ_ID]\" \"0\" \"MATCH\" \"201605*\"\r\n```\r\n\r\ncc @xavijam"},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/220963841","html_url":"https://github.com/CartoDB/cartodb/issues/7410#issuecomment-220963841","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/7410","id":220963841,"user":{"login":"javitonino","id":7569673,"avatar_url":"https://avatars.githubusercontent.com/u/7569673?v=3","gravatar_id":"","url":"https://api.github.com/users/javitonino","html_url":"https://github.com/javitonino","followers_url":"https://api.github.com/users/javitonino/followers","following_url":"https://api.github.com/users/javitonino/following{/other_user}","gists_url":"https://api.github.com/users/javitonino/gists{/gist_id}","starred_url":"https://api.github.com/users/javitonino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javitonino/subscriptions","organizations_url":"https://api.github.com/users/javitonino/orgs","repos_url":"https://api.github.com/users/javitonino/repos","events_url":"https://api.github.com/users/javitonino/events{/privacy}","received_events_url":"https://api.github.com/users/javitonino/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T12:15:46Z","updated_at":"2016-05-23T12:15:46Z","body":"After merging #7443 the load is more reasonable-ish. It still runs 4 zscan per visualization (O(n)), but it is an order of magnitude better than before. team.cartodb.com now loads in 3-4s.\r\n\r\nKeeping this in backlog for further improvement, but holding for now."}}
{"actor":{"display_login":"javitonino"}}