Hi, When working with large dataset and running a facet query, is there a way to run it in background and when the second time query run, it will be getting the result from cache?
in RDBMS, there are two concepts that will allow long running query getting better chance to finish. 1) using materialized view, so all the complex data operation for the query is pre made for the query. 2) using store procedure cache, so the when the query hit the second time, the result set is pull directly from the memory cache. Does Solr have something caching results for facet queries over large dataset? Is there example how to make facet query faster?
