{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/presto/issues/3953","labels_url":"https://api.github.com/repos/facebook/presto/issues/3953/labels{/name}","comments_url":"https://api.github.com/repos/facebook/presto/issues/3953/comments","events_url":"https://api.github.com/repos/facebook/presto/issues/3953/events","html_url":"https://github.com/facebook/presto/pull/3953","id":116469578,"number":3953,"title":"Improve performance of InCodeGenerator","user":{"login":"haozhun","id":2020503,"avatar_url":"https://avatars.githubusercontent.com/u/2020503?v=3","gravatar_id":"","url":"https://api.github.com/users/haozhun","html_url":"https://github.com/haozhun","followers_url":"https://api.github.com/users/haozhun/followers","following_url":"https://api.github.com/users/haozhun/following{/other_user}","gists_url":"https://api.github.com/users/haozhun/gists{/gist_id}","starred_url":"https://api.github.com/users/haozhun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haozhun/subscriptions","organizations_url":"https://api.github.com/users/haozhun/orgs","repos_url":"https://api.github.com/users/haozhun/repos","events_url":"https://api.github.com/users/haozhun/events{/privacy}","received_events_url":"https://api.github.com/users/haozhun/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/facebook/presto/labels/CLA%20Signed","name":"CLA Signed","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"electrum","id":9230,"avatar_url":"https://avatars.githubusercontent.com/u/9230?v=3","gravatar_id":"","url":"https://api.github.com/users/electrum","html_url":"https://github.com/electrum","followers_url":"https://api.github.com/users/electrum/followers","following_url":"https://api.github.com/users/electrum/following{/other_user}","gists_url":"https://api.github.com/users/electrum/gists{/gist_id}","starred_url":"https://api.github.com/users/electrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/electrum/subscriptions","organizations_url":"https://api.github.com/users/electrum/orgs","repos_url":"https://api.github.com/users/electrum/repos","events_url":"https://api.github.com/users/electrum/events{/privacy}","received_events_url":"https://api.github.com/users/electrum/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-11-12T02:58:56Z","updated_at":"2015-11-12T18:00:43Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/facebook/presto/pulls/3953","html_url":"https://github.com/facebook/presto/pull/3953","diff_url":"https://github.com/facebook/presto/pull/3953.diff","patch_url":"https://github.com/facebook/presto/pull/3953.patch"},"body":"* Threshold between hash set and generated switch is adjusted from 1000 to 250.\r\n* Load factor of hash set is adjusted to 0.5.\r\n\r\nBIGINT is 31-bit unsigned integers, DOUBLE is any double between 0.0 and 1.0, VARCHAR is signed 64-bit integer converted to string. Unit is microsecond for a 10000-row page.\r\n\r\n```\r\n        hash 0.75 load factor    hash 0.5 load factor      generated switch\r\n        BIGINT  DOUBLE  VARCHAR  BIGINT  DOUBLE  VARCHAR   BIGINT  DOUBLE   VARCHAR\r\n    1   235.74  225.23   706.36  182.28  181.29   588.15    39.76    51.12   254.47\r\n    5   388.62  305.17   999.64  232.17  221.40   656.43    89.19   119.79   367.25\r\n   10   427.94  360.83  1122.43  223.10  230.58   684.98   139.09   198.23   396.69\r\n   25   283.84  271.31   753.11  273.71  266.14   834.23   178.48   218.09   435.17\r\n   50   268.04  270.22   817.26  267.91  250.73   798.80   249.21   254.60   454.71\r\n   75   398.50  382.17  1306.62  232.38  233.09   650.71   262.46   278.25   484.06\r\n  100   261.93  280.38   906.26  270.54  276.77   816.94   270.46   282.47   493.71\r\n  150   424.19  395.80  1318.54  231.03  226.42   691.79   293.14   292.15   513.29\r\n  200   287.61  263.83   838.44  280.64  282.62   826.32   305.62   313.68   519.65\r\n  250   364.81  490.35  1038.71  372.73  334.62  1068.17   316.55   323.35   545.67\r\n  300   422.06  385.28  1449.77  214.26  216.09   732.39   332.34  1750.36  1955.22\r\n  350   536.78  554.96  1648.89  246.64  257.35   810.53   336.92  1774.38  2028.32\r\n  400   277.07  281.35   860.19  280.14  276.10   910.70   349.76  1784.38  1987.22\r\n  450   309.79  306.55  1019.18  304.69  304.47   956.27   352.02  1718.63  1976.81\r\n  500   391.65  343.55  1050.55  335.05  340.80  1066.33   350.37  1719.94  1968.86\r\n  750   719.82  737.52  2510.43  283.80  268.24   827.40   387.30  1827.96  2092.34\r\n 1000   350.08  345.73  1060.12  338.92  344.01  1026.75  1769.19  1800.66  2045.39\r\n10000   464.89  451.28  1786.75  244.11  237.86   750.99\r\n```"},"comment":{"url":"https://api.github.com/repos/facebook/presto/issues/comments/156184889","html_url":"https://github.com/facebook/presto/pull/3953#issuecomment-156184889","issue_url":"https://api.github.com/repos/facebook/presto/issues/3953","id":156184889,"user":{"login":"haozhun","id":2020503,"avatar_url":"https://avatars.githubusercontent.com/u/2020503?v=3","gravatar_id":"","url":"https://api.github.com/users/haozhun","html_url":"https://github.com/haozhun","followers_url":"https://api.github.com/users/haozhun/followers","following_url":"https://api.github.com/users/haozhun/following{/other_user}","gists_url":"https://api.github.com/users/haozhun/gists{/gist_id}","starred_url":"https://api.github.com/users/haozhun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haozhun/subscriptions","organizations_url":"https://api.github.com/users/haozhun/orgs","repos_url":"https://api.github.com/users/haozhun/repos","events_url":"https://api.github.com/users/haozhun/events{/privacy}","received_events_url":"https://api.github.com/users/haozhun/received_events","type":"User","site_admin":false},"created_at":"2015-11-12T18:00:43Z","updated_at":"2015-11-12T18:00:43Z","body":"https://gist.github.com/haozhun/83b5fa90f95c449dd316"}}