{"action":"created","issue":{"url":"https://api.github.com/repos/tablexi/nucore-open/issues/357","labels_url":"https://api.github.com/repos/tablexi/nucore-open/issues/357/labels{/name}","comments_url":"https://api.github.com/repos/tablexi/nucore-open/issues/357/comments","events_url":"https://api.github.com/repos/tablexi/nucore-open/issues/357/events","html_url":"https://github.com/tablexi/nucore-open/pull/357","id":107599014,"number":357,"title":"[#120379] Improve performance of all transaction view","user":{"login":"jhanggi","id":1099111,"avatar_url":"https://avatars.githubusercontent.com/u/1099111?v=3","gravatar_id":"","url":"https://api.github.com/users/jhanggi","html_url":"https://github.com/jhanggi","followers_url":"https://api.github.com/users/jhanggi/followers","following_url":"https://api.github.com/users/jhanggi/following{/other_user}","gists_url":"https://api.github.com/users/jhanggi/gists{/gist_id}","starred_url":"https://api.github.com/users/jhanggi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jhanggi/subscriptions","organizations_url":"https://api.github.com/users/jhanggi/orgs","repos_url":"https://api.github.com/users/jhanggi/repos","events_url":"https://api.github.com/users/jhanggi/events{/privacy}","received_events_url":"https://api.github.com/users/jhanggi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-21T21:09:58Z","updated_at":"2015-09-23T03:11:27Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/tablexi/nucore-open/pulls/357","html_url":"https://github.com/tablexi/nucore-open/pull/357","diff_url":"https://github.com/tablexi/nucore-open/pull/357.diff","patch_url":"https://github.com/tablexi/nucore-open/pull/357.patch"},"body":"The loading of the search options, especially when running cross-facility\r\nhas gotten fairly slow. This makes some changes to how some of those\r\noptions are loaded to speed things up.\r\n\r\nWhile testing against UIC, we discovered they're running MySQL 5.1, so some\r\nof the optimizations aren't as good as they are on 5.6+.\r\n\r\n##### Cross Facility view:\r\n\r\nMySQL version | Original | Optimized\r\n----|----|----\r\n5.1 | ~2.75s | 1.4s\r\n5.6 | ~1.5s  | 1s\r\n\r\n##### Single facility:\r\n\r\nMySQL version | Original | Optimized\r\n----|----|----\r\n5.1 | ~1.5s | 1.4s\r\n5.6 | .9s | .7s\r\n\r\nAnd from testing on staging (which is 5.1), I saw similar scale improvements:\r\n\r\nFacility view | Original | Optimized\r\n----|----|----\r\nCross | 2s | .75ms\r\nSingle | .8s | .75ms\r\n\r\nI also tested against Oracle for single facilities, and saw slight, but\r\nsimilar improvements."},"comment":{"url":"https://api.github.com/repos/tablexi/nucore-open/issues/comments/142478669","html_url":"https://github.com/tablexi/nucore-open/pull/357#issuecomment-142478669","issue_url":"https://api.github.com/repos/tablexi/nucore-open/issues/357","id":142478669,"user":{"login":"drench","id":46662,"avatar_url":"https://avatars.githubusercontent.com/u/46662?v=3","gravatar_id":"","url":"https://api.github.com/users/drench","html_url":"https://github.com/drench","followers_url":"https://api.github.com/users/drench/followers","following_url":"https://api.github.com/users/drench/following{/other_user}","gists_url":"https://api.github.com/users/drench/gists{/gist_id}","starred_url":"https://api.github.com/users/drench/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drench/subscriptions","organizations_url":"https://api.github.com/users/drench/orgs","repos_url":"https://api.github.com/users/drench/repos","events_url":"https://api.github.com/users/drench/events{/privacy}","received_events_url":"https://api.github.com/users/drench/received_events","type":"User","site_admin":false},"created_at":"2015-09-23T03:11:27Z","updated_at":"2015-09-23T03:11:27Z","body":"Just a few minor comments. There are style update possibilities here and there too, but as far as query changes go it looks all right to me."}}