(pandas-dev) root@b96d9a4128b2:/workspaces/pandas-arw2019/asv_bench# asv continuous -f 1.1 upstream/master HEAD -b io.json · Creating environments · Discovering benchmarks · Running 38 total benchmarks (2 commits * 1 environments * 19 benchmarks) [ 0.00%] · For pandas commit 7d0ee96f (round 1/2): [ 0.00%] ·· Building for conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt.... [ 0.00%] ·· Benchmarking conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt [ 1.32%] ··· Running (io.json.ReadJSON.time_read_json--). [ 6.58%] ··· Running (io.json.ReadJSONLines.time_read_json_lines--)... [ 13.16%] ··· Running (io.json.ToJSON.time_to_json--). [ 14.47%] ··· Running (io.json.ToJSON.time_to_json_wide--). [ 15.79%] ··· Running (io.json.ToJSONISO.time_iso_format--)...... [ 25.00%] · For pandas commit 9e1b95f7 (round 1/2): [ 25.00%] ·· Building for conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt.... [ 25.00%] ·· Benchmarking conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt [ 26.32%] ··· Running (io.json.ReadJSON.time_read_json--). [ 31.58%] ··· Running (io.json.ReadJSONLines.time_read_json_lines--)... [ 38.16%] ··· Running (io.json.ToJSON.time_to_json--). [ 39.47%] ··· Running (io.json.ToJSON.time_to_json_wide--). [ 40.79%] ··· Running (io.json.ToJSONISO.time_iso_format--)...... [ 50.00%] · For pandas commit 9e1b95f7 (round 2/2): [ 50.00%] ·· Benchmarking conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt [ 51.32%] ··· io.json.ReadJSON.time_read_json ok [ 51.32%] ··· ========= ============ ============ -- index --------- ------------------------- orient int datetime ========= ============ ============ split 270±3ms 283±6ms index 1.18±0.03s 1.14±0.03s records 511±20ms 507±8ms ========= ============ ============ [ 52.63%] ··· io.json.ReadJSONLines.peakmem_read_json_lines ok [ 52.63%] ··· ========== ====== index ---------- ------ int 238M datetime 238M ========== ====== [ 53.95%] ··· io.json.ReadJSONLines.peakmem_read_json_lines_concat ok [ 53.95%] ··· ========== ====== index ---------- ------ int 202M datetime 202M ========== ====== [ 55.26%] ··· io.json.ReadJSONLines.peakmem_read_json_lines_nrows ok [ 55.26%] ··· ========== ====== index ---------- ------ int 192M datetime 192M ========== ====== [ 56.58%] ··· io.json.ReadJSONLines.time_read_json_lines ok [ 56.58%] ··· ========== ========== index ---------- ---------- int 606±10ms datetime 620±20ms ========== ========== [ 57.89%] ··· io.json.ReadJSONLines.time_read_json_lines_concat ok [ 57.89%] ··· ========== ========== index ---------- ---------- int 720±20ms datetime 735±20ms ========== ========== [ 59.21%] ··· io.json.ReadJSONLines.time_read_json_lines_nrows ok [ 59.21%] ··· ========== ========= index ---------- --------- int 224±2ms datetime 233±3ms ========== ========= [ 60.53%] ··· io.json.ToJSON.peakmem_to_json ok [ 60.53%] ··· ========= ====== ============= ============== =============== ================== -- frame --------- ---------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ====== ============= ============== =============== ================== split 158M 164M 157M 164M 164M columns 168M 177M 177M 179M 180M index 166M 168M 170M 175M 175M values 157M 157M 154M 157M 157M records 165M 165M 167M 172M 172M ========= ====== ============= ============== =============== ================== [ 61.84%] ··· io.json.ToJSON.peakmem_to_json_wide ok [ 61.84%] ··· ========= ====== ============= ============== =============== ================== -- frame --------- ---------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ====== ============= ============== =============== ================== split 170M 170M 167M 173M 173M columns 179M 189M 189M 196M 195M index 180M 181M 179M 186M 185M values 170M 170M 167M 173M 172M records 180M 180M 179M 186M 185M ========= ====== ============= ============== =============== ================== [ 63.16%] ··· io.json.ToJSON.time_to_json ok [ 63.16%] ··· ========= ========= ============= ============== =============== ================== -- frame --------- ------------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ========= ============= ============== =============== ================== split 165±2ms 176±3ms 185±3ms 211±2ms 210±3ms columns 183±5ms 249±6ms 243±5ms 265±6ms 270±20ms index 204±7ms 236±10ms 278±3ms 315±40ms 295±7ms values 146±1ms 155±4ms 166±4ms 185±3ms 187±1ms records 160±2ms 178±7ms 204±8ms 226±6ms 241±6ms ========= ========= ============= ============== =============== ================== [ 64.47%] ··· io.json.ToJSON.time_to_json_wide ok [ 64.47%] ··· ========= ========== ============= ============== =============== ================== -- frame --------- -------------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ========== ============= ============== =============== ================== split 342±10ms 249±7ms 442±7ms 407±20ms 485±40ms columns 394±3ms 335±10ms 461±20ms 415±7ms 483±20ms index 376±20ms 282±20ms 478±40ms 414±20ms 494±10ms values 342±10ms 246±8ms 404±20ms 363±10ms 444±10ms records 363±9ms 278±3ms 452±9ms 393±9ms 524±10ms ========= ========== ============= ============== =============== ================== [ 65.79%] ··· io.json.ToJSONISO.time_iso_format ok [ 65.79%] ··· ========= ========== orient --------- ---------- split 473±3ms columns 489±3ms index 521±10ms values 407±5ms records 449±4ms ========= ========== [ 67.11%] ··· io.json.ToJSONLines.time_delta_int_tstamp_lines 289±7ms [ 68.42%] ··· io.json.ToJSONLines.time_float_int_lines 343±9ms [ 69.74%] ··· io.json.ToJSONLines.time_float_int_str_lines 343±7ms [ 71.05%] ··· io.json.ToJSONLines.time_floats_with_dt_index_lines 248±5ms [ 72.37%] ··· io.json.ToJSONLines.time_floats_with_int_idex_lines 239±3ms [ 73.68%] ··· Setting up io.json:232 ok [ 73.68%] ··· io.json.ToJSONMem.peakmem_float 126M [ 75.00%] ··· io.json.ToJSONMem.peakmem_int 126M [ 75.00%] · For pandas commit 7d0ee96f (round 2/2): [ 75.00%] ·· Building for conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt..... [ 75.00%] ·· Benchmarking conda-py3.6-Cython0.29.16-matplotlib-numba-numexpr-numpy-odfpy-openpyxl-pytables-pytest-scipy-sqlalchemy-xlrd-xlsxwriter-xlwt [ 76.32%] ··· io.json.ReadJSON.time_read_json ok [ 76.32%] ··· ========= ============ =========== -- index --------- ------------------------ orient int datetime ========= ============ =========== split 266±30ms 278±20ms index 1.12±0.04s 1.08±0.1s records 502±20ms 523±30ms ========= ============ =========== [ 77.63%] ··· io.json.ReadJSONLines.peakmem_read_json_lines ok [ 77.63%] ··· ========== ====== index ---------- ------ int 238M datetime 238M ========== ====== [ 78.95%] ··· io.json.ReadJSONLines.peakmem_read_json_lines_concat ok [ 78.95%] ··· ========== ====== index ---------- ------ int 202M datetime 202M ========== ====== [ 80.26%] ··· io.json.ReadJSONLines.peakmem_read_json_lines_nrows ok [ 80.26%] ··· ========== ====== index ---------- ------ int 192M datetime 192M ========== ====== [ 81.58%] ··· io.json.ReadJSONLines.time_read_json_lines ok [ 81.58%] ··· ========== ========== index ---------- ---------- int 706±30ms datetime 632±10ms ========== ========== [ 82.89%] ··· io.json.ReadJSONLines.time_read_json_lines_concat ok [ 82.89%] ··· ========== ========== index ---------- ---------- int 782±70ms datetime 781±60ms ========== ========== [ 84.21%] ··· io.json.ReadJSONLines.time_read_json_lines_nrows ok [ 84.21%] ··· ========== ========== index ---------- ---------- int 253±20ms datetime 240±20ms ========== ========== [ 85.53%] ··· io.json.ToJSON.peakmem_to_json ok [ 85.53%] ··· ========= ====== ============= ============== =============== ================== -- frame --------- ---------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ====== ============= ============== =============== ================== split 158M 164M 157M 164M 164M columns 168M 177M 177M 180M 180M index 166M 168M 170M 175M 175M values 157M 157M 154M 157M 158M records 165M 165M 167M 172M 172M ========= ====== ============= ============== =============== ================== [ 86.84%] ··· io.json.ToJSON.peakmem_to_json_wide ok [ 86.84%] ··· ========= ====== ============= ============== =============== ================== -- frame --------- ---------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ====== ============= ============== =============== ================== split 170M 170M 167M 174M 173M columns 179M 189M 189M 196M 195M index 181M 181M 179M 186M 185M values 170M 170M 167M 173M 173M records 181M 181M 179M 186M 185M ========= ====== ============= ============== =============== ================== [ 88.16%] ··· io.json.ToJSON.time_to_json ok [ 88.16%] ··· ========= ========== ============= ============== =============== ================== -- frame --------- -------------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ========== ============= ============== =============== ================== split 173±10ms 189±20ms 198±20ms 225±20ms 221±20ms columns 178±9ms 232±3ms 225±5ms 254±4ms 253±4ms index 194±2ms 218±4ms 242±3ms 268±4ms 273±5ms values 145±1ms 152±2ms 158±3ms 173±3ms 181±4ms records 162±2ms 168±4ms 200±20ms 226±7ms 226±3ms ========= ========== ============= ============== =============== ================== [ 89.47%] ··· io.json.ToJSON.time_to_json_wide ok [ 89.47%] ··· ========= ========== ============= ============== =============== ================== -- frame --------- -------------------------------------------------------------------------- orient df df_date_idx df_td_int_ts df_int_floats df_int_float_str ========= ========== ============= ============== =============== ================== split 332±10ms 247±10ms 409±20ms 364±20ms 454±10ms columns 369±10ms 324±8ms 441±10ms 398±20ms 482±20ms index 365±20ms 277±10ms 441±20ms 394±10ms 488±20ms values 327±20ms 247±10ms 409±20ms 367±10ms 463±20ms records 356±20ms 276±10ms 439±20ms 395±20ms 492±20ms ========= ========== ============= ============== =============== ================== [ 90.79%] ··· io.json.ToJSONISO.time_iso_format ok [ 90.79%] ··· ========= ========== orient --------- ---------- split 468±10ms columns 471±6ms index 480±9ms values 400±7ms records 425±10ms ========= ========== [ 92.11%] ··· io.json.ToJSONLines.time_delta_int_tstamp_lines 281±5ms [ 93.42%] ··· io.json.ToJSONLines.time_float_int_lines 335±7ms [ 94.74%] ··· io.json.ToJSONLines.time_float_int_str_lines 341±5ms [ 96.05%] ··· io.json.ToJSONLines.time_floats_with_dt_index_lines 244±2ms [ 97.37%] ··· io.json.ToJSONLines.time_floats_with_int_idex_lines 242±6ms [ 98.68%] ··· Setting up io.json:232 ok [ 98.68%] ··· io.json.ToJSONMem.peakmem_float 126M [100.00%] ··· io.json.ToJSONMem.peakmem_int 126M before after ratio [7d0ee96f] [9e1b95f7] + 268±4ms 315±40ms 1.17 io.json.ToJSON.time_to_json('index', 'df_int_floats') + 242±3ms 278±3ms 1.15 io.json.ToJSON.time_to_json('index', 'df_td_int_ts') + 364±20ms 407±20ms 1.12 io.json.ToJSON.time_to_json_wide('split', 'df_int_floats') - 706±30ms 606±10ms 0.86 io.json.ReadJSONLines.time_read_json_lines('int') SOME BENCHMARKS HAVE CHANGED SIGNIFICANTLY.