l1t1 commented on issue #9554: URL: https://github.com/apache/arrow-datafusion/issues/9554#issuecomment-1990789938
it's a bit slow. ``` with recursive t(a) as (select 1 as a union all select 1+a from t where a<10000) select count(*) from t; +----------+ | COUNT(*) | +----------+ | 10000 | +----------+ 1 row in set. Query took 2.347 seconds. ``` duckdb 0.10 : ``` D with recursive t(a) as (select 1 as a union all select 1+a from t where a<10000) select count(*) from t; Run Time (s): real 0.291 user 0.670804 sys 0.046800 D with recursive t(a) as (select 1 as a union all select 1+a from t where a<20000) select count(*) from t; Run Time (s): real 0.602 user 1.310408 sys 0.140401 D with recursive t(a) as (select 1 as a union all select 1+a from t where a<40000) select count(*) from t; Run Time (s): real 1.114 user 2.418016 sys 0.265202 D with recursive t(a) as (select 1 as a union all select 1+a from t where a<80000) select count(*) from t; Run Time (s): real 2.326 user 5.163633 sys 0.374402 ``` hyper 0.0.18161: ``` > with recursive t(a) as (select 1 as a union all select 1+a from t where a<10000) select count(*) from t; 0.061 s > with recursive t(a) as (select 1 as a union all select 1+a from t where a<20000) select count(*) from t; 0.046 s > with recursive t(a) as (select 1 as a union all select 1+a from t where a<40000) select count(*) from t; 0.052 s > with recursive t(a) as (select 1 as a union all select 1+a from t where a<80000) select count(*) from t; 0.074 s ``` -- 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]
