|
提高了一点
D:\duckdb>duckdb32
v0.3.2 5aebf7dac
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D .timer on
D create table t as select range i from range(1000000000);
Run Time: real 16.436 user 11.263272 sys 5.148033
D select sum(i) from t;
┌────────────────────┐
│ sum(i) │
├────────────────────┤
│ 499999999500000000 │
└────────────────────┘
Run Time: real 1.008 user 22.354943 sys 0.015600
D select avg(i) from t;
┌─────────────┐
│ avg(i) │
├─────────────┤
│ 499999999.5 │
└─────────────┘
Run Time: real 1.081 user 23.634152 sys 0.015600
D select count(i) from t;
┌────────────┐
│ count(i) │
├────────────┤
│ 1000000000 │
└────────────┘
Run Time: real 0.969 user 20.966534 sys 0.000000 |
|