Thanks for the confirmation about this.
Good news: as IO is the bottleneck and most of the data are not required real time, I increased refresh_interval from default (1s) to 10s. This makes the different type of queries performance max from 20s+ to 4s.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.