zhuqi-lucas commented on PR #15532:
URL: https://github.com/apache/datafusion/pull/15532#issuecomment-2771316983
More than 5X faster for clickbench Q29 with this PR:
```rust
cargo run --profile release-nonlto --target aarch64-apple-darwin --bin
dfbench -- clickbench -p benchmarks/data/hits_partitioned -q 29
Finished `release-nonlto` profile [optimized] target(s) in 0.26s
Running `target/aarch64-apple-darwin/release-nonlto/dfbench clickbench
-p benchmarks/data/hits_partitioned -q 29`
Running benchmarks with the following options: RunOpt { query: Some(29),
common: CommonOpt { iterations: 3, partitions: None, batch_size: 8192,
mem_pool_type: "fair", memory_limit: None, sort_spill_reservation_bytes: None,
debug: false }, path: "benchmarks/data/hits_partitioned", queries_path:
"benchmarks/queries/clickbench/queries.sql", output_path: None }
Q29: SELECT SUM("ResolutionWidth"), SUM("ResolutionWidth" + 1),
SUM("ResolutionWidth" + 2), SUM("ResolutionWidth" + 3), SUM("ResolutionWidth" +
4), SUM("ResolutionWidth" + 5), SUM("ResolutionWidth" + 6),
SUM("ResolutionWidth" + 7), SUM("ResolutionWidth" + 8), SUM("ResolutionWidth" +
9), SUM("ResolutionWidth" + 10), SUM("ResolutionWidth" + 11),
SUM("ResolutionWidth" + 12), SUM("ResolutionWidth" + 13), SUM("ResolutionWidth"
+ 14), SUM("ResolutionWidth" + 15), SUM("ResolutionWidth" + 16),
SUM("ResolutionWidth" + 17), SUM("ResolutionWidth" + 18), SUM("ResolutionWidth"
+ 19), SUM("ResolutionWidth" + 20), SUM("ResolutionWidth" + 21),
SUM("ResolutionWidth" + 22), SUM("ResolutionWidth" + 23), SUM("ResolutionWidth"
+ 24), SUM("ResolutionWidth" + 25), SUM("ResolutionWidth" + 26),
SUM("ResolutionWidth" + 27), SUM("ResolutionWidth" + 28), SUM("ResolutionWidth"
+ 29), SUM("ResolutionWidth" + 30), SUM("ResolutionWidth" + 31),
SUM("ResolutionWidth" + 32), SUM("ResolutionWidth" + 33), SUM("Resolu
tionWidth" + 34), SUM("ResolutionWidth" + 35), SUM("ResolutionWidth" + 36),
SUM("ResolutionWidth" + 37), SUM("ResolutionWidth" + 38), SUM("ResolutionWidth"
+ 39), SUM("ResolutionWidth" + 40), SUM("ResolutionWidth" + 41),
SUM("ResolutionWidth" + 42), SUM("ResolutionWidth" + 43), SUM("ResolutionWidth"
+ 44), SUM("ResolutionWidth" + 45), SUM("ResolutionWidth" + 46),
SUM("ResolutionWidth" + 47), SUM("ResolutionWidth" + 48), SUM("ResolutionWidth"
+ 49), SUM("ResolutionWidth" + 50), SUM("ResolutionWidth" + 51),
SUM("ResolutionWidth" + 52), SUM("ResolutionWidth" + 53), SUM("ResolutionWidth"
+ 54), SUM("ResolutionWidth" + 55), SUM("ResolutionWidth" + 56),
SUM("ResolutionWidth" + 57), SUM("ResolutionWidth" + 58), SUM("ResolutionWidth"
+ 59), SUM("ResolutionWidth" + 60), SUM("ResolutionWidth" + 61),
SUM("ResolutionWidth" + 62), SUM("ResolutionWidth" + 63), SUM("ResolutionWidth"
+ 64), SUM("ResolutionWidth" + 65), SUM("ResolutionWidth" + 66),
SUM("ResolutionWidth" + 67), SUM("ResolutionWidth"
+ 68), SUM("ResolutionWidth" + 69), SUM("ResolutionWidth" + 70),
SUM("ResolutionWidth" + 71), SUM("ResolutionWidth" + 72), SUM("ResolutionWidth"
+ 73), SUM("ResolutionWidth" + 74), SUM("ResolutionWidth" + 75),
SUM("ResolutionWidth" + 76), SUM("ResolutionWidth" + 77), SUM("ResolutionWidth"
+ 78), SUM("ResolutionWidth" + 79), SUM("ResolutionWidth" + 80),
SUM("ResolutionWidth" + 81), SUM("ResolutionWidth" + 82), SUM("ResolutionWidth"
+ 83), SUM("ResolutionWidth" + 84), SUM("ResolutionWidth" + 85),
SUM("ResolutionWidth" + 86), SUM("ResolutionWidth" + 87), SUM("ResolutionWidth"
+ 88), SUM("ResolutionWidth" + 89) FROM hits;
Query 29 iteration 0 took 77.0 ms and returned 1 rows
Query 29 iteration 1 took 57.2 ms and returned 1 rows
Query 29 iteration 2 took 42.1 ms and returned 1 rows
Query 29 avg time: 58.79 ms
```
--
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
