JayjeetAtGithub commented on issue #6782: URL: https://github.com/apache/arrow-datafusion/issues/6782#issuecomment-1730095966
Summary of benchmark results: ``` tpchsf10: +-------+------------+--------+--------------------------------+ | Query | DataFusion | DuckDB | Summary (Datafusion / DuckDB)) | +-------+------------+--------+--------------------------------+ | 1 | 18.36 | 8.07 | 2.28x slower | | 2 | 6.74 | 1.55 | 4.35x slower | | 3 | 7.24 | 7.43 | 1.03x faster | | 4 | 3.44 | 6.06 | 1.76x faster | | 5 | 11.99 | 8.68 | 1.38x slower | | 6 | 4.22 | 4.67 | 1.1x faster | | 7 | 20.42 | 13.12 | 1.56x slower | | 8 | 9.2 | 10.07 | 1.09x faster | | 9 | 18.58 | 27.66 | 1.49x faster | | 10 | 14.12 | 12.98 | 1.09x slower | | 11 | 10.95 | 0.94 | 11.67x slower | | 12 | 5.1 | 7.11 | 1.39x faster | | 13 | 16.47 | 8.64 | 1.91x slower | | 14 | 5.58 | 5.53 | 1.01x slower | | 16 | 3.16 | 1.42 | 2.23x slower | | 17 | 45.63 | 14.42 | 3.16x slower | | 18 | 41.98 | 20.86 | 2.01x slower | | 19 | 10.01 | 8.0 | 1.25x slower | | 20 | 9.97 | 8.37 | 1.19x slower | | 21 | 31.69 | 18.73 | 1.69x slower | | 22 | 8.28 | 2.07 | 4.0x slower | +-------+------------+--------+--------------------------------+ h2o: +-------+------------+--------+--------------------------------+ | Query | DataFusion | DuckDB | Summary (Datafusion / DuckDB)) | +-------+------------+--------+--------------------------------+ | 1 | 2.35 | 4.77 | 2.04x faster | | 2 | 3.26 | 5.48 | 1.68x faster | | 3 | 4.61 | 6.16 | 1.34x faster | | 4 | 2.77 | 5.13 | 1.85x faster | | 5 | 4.06 | 6.4 | 1.58x faster | | 6 | 9.43 | 6.14 | 1.54x slower | | 7 | 4.08 | 5.75 | 1.41x faster | | 8 | 8.74 | 8.22 | 1.06x slower | | 9 | 14.03 | 5.83 | 2.41x slower | | 10 | 58.91 | 24.19 | 2.44x slower | +-------+------------+--------+--------------------------------+ clickbench: +-------+------------+--------+--------------------------------+ | Query | DataFusion | DuckDB | Summary (Datafusion / DuckDB)) | +-------+------------+--------+--------------------------------+ | 1 | 1.14 | 0.1 | 11.37x slower | | 2 | 0.41 | 0.73 | 1.78x faster | | 3 | 1.16 | 1.66 | 1.43x faster | | 4 | 1.09 | 1.37 | 1.26x faster | | 5 | 15.79 | 14.9 | 1.06x slower | | 6 | 14.04 | 11.28 | 1.24x slower | | 7 | 0.34 | 2.02 | 5.96x faster | | 8 | 0.42 | 0.73 | 1.75x faster | | 9 | 18.13 | 8.83 | 2.05x slower | | 10 | 22.07 | 12.52 | 1.76x slower | | 11 | 3.81 | 3.04 | 1.26x slower | | 12 | 4.26 | 3.81 | 1.12x slower | | 13 | 8.84 | 10.78 | 1.22x faster | | 14 | 19.85 | 14.09 | 1.41x slower | | 15 | 9.69 | 10.69 | 1.1x faster | | 16 | 9.51 | 7.73 | 1.23x slower | | 17 | 21.43 | 19.94 | 1.07x slower | | 18 | 20.54 | 19.69 | 1.04x slower | | 19 | 63.37 | 35.32 | 1.79x slower | | 20 | 0.82 | 1.19 | 1.44x faster | | 25 | 6.38 | 8.25 | 1.29x faster | | 26 | 4.86 | 6.04 | 1.24x faster | | 27 | 6.04 | 8.31 | 1.37x faster | | 28 | 31.51 | 23.35 | 1.35x slower | | 29 | 100.81 | 64.59 | 1.56x slower | | 30 | 6.01 | 17.22 | 2.86x faster | | 31 | 10.99 | 12.4 | 1.13x faster | | 32 | 12.52 | 15.02 | 1.2x faster | | 33 | 67.21 | 48.38 | 1.39x slower | | 36 | 24.0 | 8.03 | 2.99x slower | | 37 | 0.6 | 1.12 | 1.85x faster | | 38 | 0.37 | 0.83 | 2.22x faster | | 39 | 0.37 | 1.55 | 4.25x faster | | 40 | 1.7 | 1.87 | 1.1x faster | | 41 | 0.22 | 0.63 | 2.85x faster | | 42 | 0.2 | 0.68 | 3.4x faster | | 43 | 0.22 | 1.53 | 7.04x faster | +-------+------------+--------+--------------------------------+ ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
