{"action":"created","issue":{"url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/issues/20","labels_url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/issues/20/comments","events_url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/issues/20/events","html_url":"https://github.com/opencloset/OpenCloset-Schema/pull/20","id":58497898,"number":20,"title":"Prefetch 'status' table to increase speed","user":{"login":"yongbin","id":52704,"avatar_url":"https://avatars.githubusercontent.com/u/52704?v=3","gravatar_id":"","url":"https://api.github.com/users/yongbin","html_url":"https://github.com/yongbin","followers_url":"https://api.github.com/users/yongbin/followers","following_url":"https://api.github.com/users/yongbin/following{/other_user}","gists_url":"https://api.github.com/users/yongbin/gists{/gist_id}","starred_url":"https://api.github.com/users/yongbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yongbin/subscriptions","organizations_url":"https://api.github.com/users/yongbin/orgs","repos_url":"https://api.github.com/users/yongbin/repos","events_url":"https://api.github.com/users/yongbin/events{/privacy}","received_events_url":"https://api.github.com/users/yongbin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"keedi","id":138451,"avatar_url":"https://avatars.githubusercontent.com/u/138451?v=3","gravatar_id":"","url":"https://api.github.com/users/keedi","html_url":"https://github.com/keedi","followers_url":"https://api.github.com/users/keedi/followers","following_url":"https://api.github.com/users/keedi/following{/other_user}","gists_url":"https://api.github.com/users/keedi/gists{/gist_id}","starred_url":"https://api.github.com/users/keedi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keedi/subscriptions","organizations_url":"https://api.github.com/users/keedi/orgs","repos_url":"https://api.github.com/users/keedi/repos","events_url":"https://api.github.com/users/keedi/events{/privacy}","received_events_url":"https://api.github.com/users/keedi/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/milestones/8","labels_url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/milestones/8/labels","id":980835,"number":8,"title":" release-0.009","description":"- Order.analyze_order_status_logs(): 성능 향상을 위해 status 테이블을 미리 적재함 (#20)\r\n","creator":{"login":"keedi","id":138451,"avatar_url":"https://avatars.githubusercontent.com/u/138451?v=3","gravatar_id":"","url":"https://api.github.com/users/keedi","html_url":"https://github.com/keedi","followers_url":"https://api.github.com/users/keedi/followers","following_url":"https://api.github.com/users/keedi/following{/other_user}","gists_url":"https://api.github.com/users/keedi/gists{/gist_id}","starred_url":"https://api.github.com/users/keedi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keedi/subscriptions","organizations_url":"https://api.github.com/users/keedi/orgs","repos_url":"https://api.github.com/users/keedi/repos","events_url":"https://api.github.com/users/keedi/events{/privacy}","received_events_url":"https://api.github.com/users/keedi/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2015-02-16T08:16:06Z","updated_at":"2015-02-23T07:06:52Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-02-22T10:24:03Z","updated_at":"2015-02-23T07:09:44Z","closed_at":"2015-02-23T07:03:18Z","pull_request":{"url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/pulls/20","html_url":"https://github.com/opencloset/OpenCloset-Schema/pull/20","diff_url":"https://github.com/opencloset/OpenCloset-Schema/pull/20.diff","patch_url":"https://github.com/opencloset/OpenCloset-Schema/pull/20.patch"},"body":"analyze_order_status_logs 함수는 상태에 대한 이름을 알기위해서\r\nstatus->name에 접근하기때문에 성능의 저하가 발생합니다. DBIC에서\r\n제공하는 'prefetch' 속성을 이용하면 해당 테이블에 접근할때 추가쿼리가\r\n발생하지 않도록 미리 지정된 테이블이 값을 저장하기 때문에 DB로 보내는\r\n쿼리를 줄일수 있습니다."},"comment":{"url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/issues/comments/75497356","html_url":"https://github.com/opencloset/OpenCloset-Schema/pull/20#issuecomment-75497356","issue_url":"https://api.github.com/repos/opencloset/OpenCloset-Schema/issues/20","id":75497356,"user":{"login":"keedi","id":138451,"avatar_url":"https://avatars.githubusercontent.com/u/138451?v=3","gravatar_id":"","url":"https://api.github.com/users/keedi","html_url":"https://github.com/keedi","followers_url":"https://api.github.com/users/keedi/followers","following_url":"https://api.github.com/users/keedi/following{/other_user}","gists_url":"https://api.github.com/users/keedi/gists{/gist_id}","starred_url":"https://api.github.com/users/keedi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keedi/subscriptions","organizations_url":"https://api.github.com/users/keedi/orgs","repos_url":"https://api.github.com/users/keedi/repos","events_url":"https://api.github.com/users/keedi/events{/privacy}","received_events_url":"https://api.github.com/users/keedi/received_events","type":"User","site_admin":false},"created_at":"2015-02-23T07:09:44Z","updated_at":"2015-02-23T07:09:44Z","body":"0.009 버전 릴리스 완료했습니다."}}