Time of reading data

It has been observed that the first run of reading takes a bit more time. Is it for reserving resources?

Hi @sps ,

I think that most probably the data is on disk at first read and not in cache.

The consecutive times its probably read from cache.

You need to index and size your deployment based on your use case. Perhaps pre hitting the cache when system starts is advised by running those heavy read queries…

Thanks
Pavel

Thanks a lot.
I am very sorry to reply late.