JoeryH commented on PR #26317:
URL: https://github.com/apache/datafusion/pull/26317#issuecomment-6991111452
> > No. Planning is faster and plans are identical.
>
> What evidence do we haev that planning is faster?
The sql_planner benches added here (cargo bench -p datafusion --bench
sql_planner -- logical_nested;
CLICKBENCH_DATA_PATH=datafusion/core/tests/data/clickbench_hits_10.parquet is
enough, the nested cases plan against an in-memory 700-column table). Rerun
just now, main vs this PR:
| case | main | this PR |
|---------------------|----------|---------|
| 700 cols × 8 levels | 168.2 ms | 50.3 ms |
| 700 × 1 | 14.7 ms | 11.0 ms |
| 100 × 8 | 8.5 ms | 5.9 ms |
| 100 × 1 | 1.66 ms | 1.57 ms |
| q.* 700 × 8 | 18.2 ms | 18.3 ms |
| q.* 700 × 1 | 3.96 ms | 4.01 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]