query and insert very slow

[8188]

environment: laptop, windows10, docker desktop cnosdb:community-latest
table: 4000 columns
query by cli:
public ❯ select count(time) from booltest;
+----------------------+
| COUNT(booltest.time) |
+----------------------+
| 30 |
+----------------------+
Query took 2.893 seconds.
insert: as slow as query
when use influxdb, the same table, insert 10 datum only takes 100ms around

[h4ofanya]

environment: Mac and docker cnosdb:community-latest
table: 4000 double columns without any data
Mac:
public ❯ select count(time) from air;
+-----------------+
| COUNT(air.time) |
+-----------------+
| 0 |
+-----------------+
Query took 21.938 seconds.

docker:
+-----------------+
| COUNT(air.time) |
+-----------------+
| 0 |
+-----------------+
Query took 2.147 seconds.

[roseboy-liu]

environment: Mac and docker cnosdb:community-latest table: 4000 double columns without any data Mac: public ❯ select count(time) from air; +-----------------+ | COUNT(air.time) | +-----------------+ | 0 | +-----------------+ Query took 21.938 seconds.

docker: +-----------------+ | COUNT(air.time) | +-----------------+ | 0 | +-----------------+ Query took 2.147 seconds.

did you build release mode on mac env ? looks like debug mode running.