zhuqi-lucas opened a new pull request, #15447: URL: https://github.com/apache/datafusion/pull/15447
…ng on a single Utf8View ) ## Which issue does this PR close? - Closes [#15403](https://github.com/apache/datafusion/issues/15403) ## Rationale for this change Improve performance sort TPCH q3 with Utf8Vew ( Sort-preserving merging on a single Utf8View ) ## What changes are included in this PR? Improve performance sort TPCH q3 with Utf8Vew ( Sort-preserving merging on a single Utf8View ) ## Are these changes tested? Yes python3 ./compare.py ./results/main/sort_tpch.json ./results/issue_15403/sort_tpch.json ┏━━━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓ ┃ Query ┃ main ┃ issue_15403 ┃ Change ┃ ┡━━━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩ │ Q1 │ 153.67ms │ 145.64ms │ +1.06x faster │ │ Q2 │ 129.33ms │ 132.22ms │ no change │ │ Q3 │ 1341.97ms │ 964.69ms │ +1.39x faster │ │ Q4 │ 224.86ms │ 224.15ms │ no change │ │ Q5 │ 410.67ms │ 406.52ms │ no change │ │ Q6 │ 425.51ms │ 420.21ms │ no change │ │ Q7 │ 651.09ms │ 644.93ms │ no change │ │ Q8 │ 458.20ms │ 463.22ms │ no change │ │ Q9 │ 476.74ms │ 472.85ms │ no change │ │ Q10 │ 679.90ms │ 667.38ms │ no change │ │ Q11 │ 414.58ms │ 427.22ms │ no change │ └──────────────┴───────────┴─────────────┴───────────────┘ ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━┓ ┃ Benchmark Summary ┃ ┃ ┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━┩ │ Total Time (main) │ 5366.53ms │ │ Total Time (issue_15403) │ 4969.04ms │ │ Average Time (main) │ 487.87ms │ │ Average Time (issue_15403) │ 451.73ms │ │ Queries Faster │ 2 │ │ Queries Slower │ 0 │ │ Queries with No Change │ 9 │ └────────────────────────────┴───────────┘ ## Are there any user-facing changes? No -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
