{"action":"created","issue":{"url":"https://api.github.com/repos/mceachen/closure_tree/issues/178","labels_url":"https://api.github.com/repos/mceachen/closure_tree/issues/178/labels{/name}","comments_url":"https://api.github.com/repos/mceachen/closure_tree/issues/178/comments","events_url":"https://api.github.com/repos/mceachen/closure_tree/issues/178/events","html_url":"https://github.com/mceachen/closure_tree/pull/178","id":107090213,"number":178,"title":"Performance tweaks","user":{"login":"magnusfiorepalm","id":12837033,"avatar_url":"https://avatars.githubusercontent.com/u/12837033?v=3","gravatar_id":"","url":"https://api.github.com/users/magnusfiorepalm","html_url":"https://github.com/magnusfiorepalm","followers_url":"https://api.github.com/users/magnusfiorepalm/followers","following_url":"https://api.github.com/users/magnusfiorepalm/following{/other_user}","gists_url":"https://api.github.com/users/magnusfiorepalm/gists{/gist_id}","starred_url":"https://api.github.com/users/magnusfiorepalm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/magnusfiorepalm/subscriptions","organizations_url":"https://api.github.com/users/magnusfiorepalm/orgs","repos_url":"https://api.github.com/users/magnusfiorepalm/repos","events_url":"https://api.github.com/users/magnusfiorepalm/events{/privacy}","received_events_url":"https://api.github.com/users/magnusfiorepalm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-17T22:40:25Z","updated_at":"2015-10-03T05:22:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mceachen/closure_tree/pulls/178","html_url":"https://github.com/mceachen/closure_tree/pull/178","diff_url":"https://github.com/mceachen/closure_tree/pull/178.diff","patch_url":"https://github.com/mceachen/closure_tree/pull/178.patch"},"body":"We noticed that certain queries using sub selects are fairly slow on a bigger recordset. Our hierarchy table contains 80+ million records causing these queries to take a long time.\r\n\r\nThe added additional queries avoid the performance issue by minimizing the record sets in the sub selects before the join with the outer table."},"comment":{"url":"https://api.github.com/repos/mceachen/closure_tree/issues/comments/145201355","html_url":"https://github.com/mceachen/closure_tree/pull/178#issuecomment-145201355","issue_url":"https://api.github.com/repos/mceachen/closure_tree/issues/178","id":145201355,"user":{"login":"mceachen","id":216377,"avatar_url":"https://avatars.githubusercontent.com/u/216377?v=3","gravatar_id":"","url":"https://api.github.com/users/mceachen","html_url":"https://github.com/mceachen","followers_url":"https://api.github.com/users/mceachen/followers","following_url":"https://api.github.com/users/mceachen/following{/other_user}","gists_url":"https://api.github.com/users/mceachen/gists{/gist_id}","starred_url":"https://api.github.com/users/mceachen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mceachen/subscriptions","organizations_url":"https://api.github.com/users/mceachen/orgs","repos_url":"https://api.github.com/users/mceachen/repos","events_url":"https://api.github.com/users/mceachen/events{/privacy}","received_events_url":"https://api.github.com/users/mceachen/received_events","type":"User","site_admin":false},"created_at":"2015-10-03T05:22:24Z","updated_at":"2015-10-03T05:22:24Z","body":"Thanks for the PR! Sorry for the latency.\r\n\r\nI fixed the merge conflicts in my branch. If you want to check out my branch and verify my change to the `hash_tree` query is still performant, that'd be great—it's not quite the same, but it should still work."}}