Is it possible to implement cache for Cassandra Queries Data using Virtual index in Splunk Hunk?

[basilarockiaedw]

I am retrieving data from cassandra to build dashboards and it is taking 4 to 5 seconds every time to load the results to dashboard.
Is there any caching technology/framework can we deploy between cassandra and Splunk to retrieve data much faster and also to avoid multiple db calls for the same query from the different users?

[rdagan_splunk · Accepted solution]

Putting the data into a summary index or report acceleration might do the trick.
For example, index=cassandra | collect index=abc or schedule search that insert the data into a summary index.

[basilarockiaedw]

looking for an answer for this post.can anyone help in getting this implemented?