{"action":"opened","issue":{"url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/issues/559","labels_url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/issues/559/labels{/name}","comments_url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/issues/559/comments","events_url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/issues/559/events","html_url":"https://github.com/Cal-CS-61A-Staff/ok/issues/559","id":98626645,"number":559,"title":"Search speed issues: num_per_page, n+1","user":{"login":"alvinwan","id":2068077,"avatar_url":"https://avatars.githubusercontent.com/u/2068077?v=3","gravatar_id":"","url":"https://api.github.com/users/alvinwan","html_url":"https://github.com/alvinwan","followers_url":"https://api.github.com/users/alvinwan/followers","following_url":"https://api.github.com/users/alvinwan/following{/other_user}","gists_url":"https://api.github.com/users/alvinwan/gists{/gist_id}","starred_url":"https://api.github.com/users/alvinwan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alvinwan/subscriptions","organizations_url":"https://api.github.com/users/alvinwan/orgs","repos_url":"https://api.github.com/users/alvinwan/repos","events_url":"https://api.github.com/users/alvinwan/events{/privacy}","received_events_url":"https://api.github.com/users/alvinwan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/labels/frontend","name":"frontend","color":"c7def8"},{"url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/labels/server","name":"server","color":"0052cc"}],"state":"open","locked":false,"assignee":{"login":"alvinwan","id":2068077,"avatar_url":"https://avatars.githubusercontent.com/u/2068077?v=3","gravatar_id":"","url":"https://api.github.com/users/alvinwan","html_url":"https://github.com/alvinwan","followers_url":"https://api.github.com/users/alvinwan/followers","following_url":"https://api.github.com/users/alvinwan/following{/other_user}","gists_url":"https://api.github.com/users/alvinwan/gists{/gist_id}","starred_url":"https://api.github.com/users/alvinwan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alvinwan/subscriptions","organizations_url":"https://api.github.com/users/alvinwan/orgs","repos_url":"https://api.github.com/users/alvinwan/repos","events_url":"https://api.github.com/users/alvinwan/events{/privacy}","received_events_url":"https://api.github.com/users/alvinwan/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/milestones/6","html_url":"https://github.com/Cal-CS-61A-Staff/ok/milestones/Performance","labels_url":"https://api.github.com/repos/Cal-CS-61A-Staff/ok/milestones/6/labels","id":996635,"number":6,"title":"Performance","description":"- [ ] reduce all page load times to ~1-2s max.\r\n- [ ] kill all n+1 queries\r\n- [ ] replace libraries where possible","creator":{"login":"Sumukh","id":882381,"avatar_url":"https://avatars.githubusercontent.com/u/882381?v=3","gravatar_id":"","url":"https://api.github.com/users/Sumukh","html_url":"https://github.com/Sumukh","followers_url":"https://api.github.com/users/Sumukh/followers","following_url":"https://api.github.com/users/Sumukh/following{/other_user}","gists_url":"https://api.github.com/users/Sumukh/gists{/gist_id}","starred_url":"https://api.github.com/users/Sumukh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sumukh/subscriptions","organizations_url":"https://api.github.com/users/Sumukh/orgs","repos_url":"https://api.github.com/users/Sumukh/repos","events_url":"https://api.github.com/users/Sumukh/events{/privacy}","received_events_url":"https://api.github.com/users/Sumukh/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":2,"state":"open","created_at":"2015-02-26T09:19:47Z","updated_at":"2015-08-02T18:31:42Z","due_on":"2015-12-31T08:00:00Z","closed_at":null},"comments":0,"created_at":"2015-08-02T18:31:42Z","updated_at":"2015-08-02T18:31:42Z","closed_at":null,"body":"While investigating #557, I noticed two things:\r\n\r\n- [ ] `num_per_page` has no effect\r\n- [ ] looks like there's an n+1 query happening somewhere, per the image below\r\n\r\n![screen shot 2015-08-02 at 11 29 09 am](https://cloud.githubusercontent.com/assets/2068077/9027447/f0653d0c-3909-11e5-9c37-9718a4574b20.png)\r\n"}}