{"action":"created","issue":{"url":"https://api.github.com/repos/danielmmetz/cs133_project/issues/27","labels_url":"https://api.github.com/repos/danielmmetz/cs133_project/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/danielmmetz/cs133_project/issues/27/comments","events_url":"https://api.github.com/repos/danielmmetz/cs133_project/issues/27/events","html_url":"https://github.com/danielmmetz/cs133_project/pull/27","id":121188009,"number":27,"title":"load intermediate table into memory","user":{"login":"ericthewry","id":10351855,"avatar_url":"https://avatars.githubusercontent.com/u/10351855?v=3","gravatar_id":"","url":"https://api.github.com/users/ericthewry","html_url":"https://github.com/ericthewry","followers_url":"https://api.github.com/users/ericthewry/followers","following_url":"https://api.github.com/users/ericthewry/following{/other_user}","gists_url":"https://api.github.com/users/ericthewry/gists{/gist_id}","starred_url":"https://api.github.com/users/ericthewry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericthewry/subscriptions","organizations_url":"https://api.github.com/users/ericthewry/orgs","repos_url":"https://api.github.com/users/ericthewry/repos","events_url":"https://api.github.com/users/ericthewry/events{/privacy}","received_events_url":"https://api.github.com/users/ericthewry/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-09T08:44:15Z","updated_at":"2015-12-09T18:54:37Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/danielmmetz/cs133_project/pulls/27","html_url":"https://github.com/danielmmetz/cs133_project/pull/27","diff_url":"https://github.com/danielmmetz/cs133_project/pull/27.diff","patch_url":"https://github.com/danielmmetz/cs133_project/pull/27.patch"},"body":"Hey so, I made some of the changes I was talking about in the other PR. I think we can still cut down some of the load time.  Here are some one-off times I got from my computer:\r\n\r\nOld Version:\r\n```\r\nCompleted 200 OK in 24836ms (Views: 21701.5ms | ActiveRecord: 3132.5ms)\r\n```\r\n\r\nThis Version\r\n```\r\nCompleted 200 OK in 951ms (Views: 934.9ms | ActiveRecord: 15.0ms)\r\n```\r\n\r\nIn this version, all the calculation is happening in the views, so it makes sense they'd take the longest.\r\nThis also suggests to me that 30 entries. is probably too long.\r\n\r\nLet me know what you think.\r\nWe should talk about this more tomorrow.\r\n"},"comment":{"url":"https://api.github.com/repos/danielmmetz/cs133_project/issues/comments/163356506","html_url":"https://github.com/danielmmetz/cs133_project/pull/27#issuecomment-163356506","issue_url":"https://api.github.com/repos/danielmmetz/cs133_project/issues/27","id":163356506,"user":{"login":"ericthewry","id":10351855,"avatar_url":"https://avatars.githubusercontent.com/u/10351855?v=3","gravatar_id":"","url":"https://api.github.com/users/ericthewry","html_url":"https://github.com/ericthewry","followers_url":"https://api.github.com/users/ericthewry/followers","following_url":"https://api.github.com/users/ericthewry/following{/other_user}","gists_url":"https://api.github.com/users/ericthewry/gists{/gist_id}","starred_url":"https://api.github.com/users/ericthewry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericthewry/subscriptions","organizations_url":"https://api.github.com/users/ericthewry/orgs","repos_url":"https://api.github.com/users/ericthewry/repos","events_url":"https://api.github.com/users/ericthewry/events{/privacy}","received_events_url":"https://api.github.com/users/ericthewry/received_events","type":"User","site_admin":false},"created_at":"2015-12-09T18:54:37Z","updated_at":"2015-12-09T18:54:37Z","body":"Bug fixed. @danielmmetz ?"}}