I loaded up 13 million rows for test to see if this DB is something I can use.
I am back filling 3 years worth of data and after loading around 13M rows I am getting this for a simple count. 15 minutes to select count 13M rows…
In general the query performance is not very good.
The system is a 24 core / dual xeon cpu with SSD. I am not running any other queries and the system is generally idle. Nothing in the logs point to an issue and the linux syslog are normal.
I do not have that much experience with time series database so perhaps the performance is normal ?
time influx -database ‘test’ -execute 'select count(*) from test’