{"action":"created","issue":{"url":"https://api.github.com/repos/paultag/moxie/issues/75","labels_url":"https://api.github.com/repos/paultag/moxie/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/paultag/moxie/issues/75/comments","events_url":"https://api.github.com/repos/paultag/moxie/issues/75/events","html_url":"https://github.com/paultag/moxie/pull/75","id":99710404,"number":75,"title":"Improve speed an remove SQL injection surface","user":{"login":"mileswwatkins","id":4959135,"avatar_url":"https://avatars.githubusercontent.com/u/4959135?v=3","gravatar_id":"","url":"https://api.github.com/users/mileswwatkins","html_url":"https://github.com/mileswwatkins","followers_url":"https://api.github.com/users/mileswwatkins/followers","following_url":"https://api.github.com/users/mileswwatkins/following{/other_user}","gists_url":"https://api.github.com/users/mileswwatkins/gists{/gist_id}","starred_url":"https://api.github.com/users/mileswwatkins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mileswwatkins/subscriptions","organizations_url":"https://api.github.com/users/mileswwatkins/orgs","repos_url":"https://api.github.com/users/mileswwatkins/repos","events_url":"https://api.github.com/users/mileswwatkins/events{/privacy}","received_events_url":"https://api.github.com/users/mileswwatkins/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-08-07T19:13:41Z","updated_at":"2015-08-08T20:42:14Z","closed_at":"2015-08-08T16:47:25Z","pull_request":{"url":"https://api.github.com/repos/paultag/moxie/pulls/75","html_url":"https://github.com/paultag/moxie/pull/75","diff_url":"https://github.com/paultag/moxie/pull/75.diff","patch_url":"https://github.com/paultag/moxie/pull/75.patch"},"body":"Rejiggered the code so that `Job` filtering doesn't happen in raw SQL, and so we're now safe on that front.\r\n\r\nAlso, realized that the views that use the `Job`–`Run` lists don't need the `Run.log`s, which in some cases are enormous and were the main reason the views were so slow. Removed `Run.log`s from every query I could, and now performance should be better."},"comment":{"url":"https://api.github.com/repos/paultag/moxie/issues/comments/129043369","html_url":"https://github.com/paultag/moxie/pull/75#issuecomment-129043369","issue_url":"https://api.github.com/repos/paultag/moxie/issues/75","id":129043369,"user":{"login":"mileswwatkins","id":4959135,"avatar_url":"https://avatars.githubusercontent.com/u/4959135?v=3","gravatar_id":"","url":"https://api.github.com/users/mileswwatkins","html_url":"https://github.com/mileswwatkins","followers_url":"https://api.github.com/users/mileswwatkins/followers","following_url":"https://api.github.com/users/mileswwatkins/following{/other_user}","gists_url":"https://api.github.com/users/mileswwatkins/gists{/gist_id}","starred_url":"https://api.github.com/users/mileswwatkins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mileswwatkins/subscriptions","organizations_url":"https://api.github.com/users/mileswwatkins/orgs","repos_url":"https://api.github.com/users/mileswwatkins/repos","events_url":"https://api.github.com/users/mileswwatkins/events{/privacy}","received_events_url":"https://api.github.com/users/mileswwatkins/received_events","type":"User","site_admin":false},"created_at":"2015-08-08T20:42:14Z","updated_at":"2015-08-08T20:42:14Z","body":"Production works well now! <3"}}