Rachelint commented on PR #15591:
URL: https://github.com/apache/datafusion/pull/15591#issuecomment-2823308363
I add a query in `extened.sql`, the blocked approach can get a obvious
improvement as expected:
- sql:
```sql
SELECT "WatchID", MIN("ResolutionWidth"), MAX("ResolutionWidth"),
SUM("IsRefresh") FROM hits GROUP BY "WatchID" ORDER BY "WatchID" DESC LIMIT 10;
```
- disable blocked approach:
```
Query 7 iteration 0 took 8532.5 ms and returned 10 rows
Query 7 iteration 1 took 8214.4 ms and returned 10 rows
Query 7 iteration 2 took 8017.6 ms and returned 10 rows
Query 7 iteration 3 took 8283.9 ms and returned 10 rows
Query 7 iteration 4 took 7913.1 ms and returned 10 rows
Query 7 avg time: 8192.27 ms
```
- enable blocked approach:
```
Query 7 iteration 0 took 7613.3 ms and returned 10 rows
Query 7 iteration 1 took 7252.4 ms and returned 10 rows
Query 7 iteration 2 took 7520.5 ms and returned 10 rows
Query 7 iteration 3 took 7193.6 ms and returned 10 rows
Query 7 iteration 4 took 7235.4 ms and returned 10 rows
Query 7 avg time: 7363.00 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
