i have a TopN Query, which gets the last dataset of the last seven days with a granularity of “day”.
This queue works fine, but has a latency of 800ms to 1.2 seconds, which i try to lower. The database has about 2.4 Billion Datasets and 90 GB of data stored in one datasource.
Now i read, that with setting chunkPeriod i am able to paralise the query and maybe speed up the queue.
When i execute the query with a chunkPeriod of “P1D” i just retrieve a single day, instead of seven. When i use “P2D”, i retrieve one day with two results which are the same.
I read in another thread, that i have to set “merge on” at the server(s), where the only merge i found was at the coordinator configuration, but i don’t think, that this is the right one.
Did i missunderstood the chunkPeriod feature or maybe someone can point me to the right way