{"action":"created","issue":{"url":"https://api.github.com/repos/18F/openFEC/issues/1204","labels_url":"https://api.github.com/repos/18F/openFEC/issues/1204/labels{/name}","comments_url":"https://api.github.com/repos/18F/openFEC/issues/1204/comments","events_url":"https://api.github.com/repos/18F/openFEC/issues/1204/events","html_url":"https://github.com/18F/openFEC/issues/1204","id":106695978,"number":1204,"title":"Improve performance on receipts and disbursements queries","user":{"login":"jmcarp","id":1633460,"avatar_url":"https://avatars.githubusercontent.com/u/1633460?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcarp","html_url":"https://github.com/jmcarp","followers_url":"https://api.github.com/users/jmcarp/followers","following_url":"https://api.github.com/users/jmcarp/following{/other_user}","gists_url":"https://api.github.com/users/jmcarp/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcarp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcarp/subscriptions","organizations_url":"https://api.github.com/users/jmcarp/orgs","repos_url":"https://api.github.com/users/jmcarp/repos","events_url":"https://api.github.com/users/jmcarp/events{/privacy}","received_events_url":"https://api.github.com/users/jmcarp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"jmcarp","id":1633460,"avatar_url":"https://avatars.githubusercontent.com/u/1633460?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcarp","html_url":"https://github.com/jmcarp","followers_url":"https://api.github.com/users/jmcarp/followers","following_url":"https://api.github.com/users/jmcarp/following{/other_user}","gists_url":"https://api.github.com/users/jmcarp/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcarp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcarp/subscriptions","organizations_url":"https://api.github.com/users/jmcarp/orgs","repos_url":"https://api.github.com/users/jmcarp/repos","events_url":"https://api.github.com/users/jmcarp/events{/privacy}","received_events_url":"https://api.github.com/users/jmcarp/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-09-16T04:22:30Z","updated_at":"2015-09-18T14:21:16Z","closed_at":null,"body":"Some queries against the receipts and disbursements tables are slower than expected. Performance should be improved here. Slow queries may include the following:\r\n\r\n* [ ] Queries by state or city for rare states and cities\r\n* [ ] Full-text queries against disbursement purpose\r\n* [ ] Full-text queries combined with other filters\r\n\r\nI'd like to get all of these queries, and anything else that folks find, to respond within a few seconds at most. I have some ideas about improving performance here and will update the issue as queries get faster.\r\n\r\nh/t @leahbannon "},"comment":{"url":"https://api.github.com/repos/18F/openFEC/issues/comments/141464587","html_url":"https://github.com/18F/openFEC/issues/1204#issuecomment-141464587","issue_url":"https://api.github.com/repos/18F/openFEC/issues/1204","id":141464587,"user":{"login":"LindsayYoung","id":4406333,"avatar_url":"https://avatars.githubusercontent.com/u/4406333?v=3","gravatar_id":"","url":"https://api.github.com/users/LindsayYoung","html_url":"https://github.com/LindsayYoung","followers_url":"https://api.github.com/users/LindsayYoung/followers","following_url":"https://api.github.com/users/LindsayYoung/following{/other_user}","gists_url":"https://api.github.com/users/LindsayYoung/gists{/gist_id}","starred_url":"https://api.github.com/users/LindsayYoung/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LindsayYoung/subscriptions","organizations_url":"https://api.github.com/users/LindsayYoung/orgs","repos_url":"https://api.github.com/users/LindsayYoung/repos","events_url":"https://api.github.com/users/LindsayYoung/events{/privacy}","received_events_url":"https://api.github.com/users/LindsayYoung/received_events","type":"User","site_admin":false},"created_at":"2015-09-18T14:21:16Z","updated_at":"2015-09-18T14:21:16Z","body":"Sorting by amount takes a while too"}}