Greetings @klim, Correct me if I'm misunderstanding, but I doubt your search is so big that you can't do a "one-time" load into memory of the results, and then filter them in-memory instead of creating a new search to send back to the indexers. Below is a run-anywhere dashboard of what I'm talking about. The base search runs on dashboard load, however, changing either of the two drop-downs does NOT initiate any kind of reload. Instead, they filter the results that have already been retrieved by the base search. In my example, changing the time selector DOES require a new search because the time selector changes the base search itself. <form>
<search id="baseSearch">
<query>index=_internal
| table _time index sourcetype source host component _raw</query>
<earliest>$timeSelector.earliest$</earliest>
<latest>$timeSelector.latest$</latest>
</search>
<description>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-accelerate-a-search-that-uses-values-from-a-dropdown/m-p/540310#M37024</description>
<fieldset submitButton="false">
<input type="time" token="timeSelector" searchWhenChanged="true">
<label>Time Selector</label>
<default>
<earliest>-24h@h</earliest>
<latest>now</latest>
</default>
</input>
<input type="dropdown" token="sourcetype" searchWhenChanged="true">
<label>sourcetype</label>
<choice value="*">All</choice>
<default>*</default>
<prefix>sourcetype="</prefix>
<suffix>"</suffix>
<initialValue>*</initialValue>
<fieldForLabel>sourcetype</fieldForLabel>
<fieldForValue>sourcetype</fieldForValue>
<search base="baseSearch">
<query>dedup sourcetype | fields sourcetype | sort sourcetype</query>
</search>
</input>
<input type="dropdown" token="component" searchWhenChanged="true">
<label>component</label>
<choice value="*">All</choice>
<default>*</default>
<prefix>component="</prefix>
<suffix>"</suffix>
<initialValue>*</initialValue>
<fieldForLabel>component</fieldForLabel>
<fieldForValue>component</fieldForValue>
<search base="baseSearch">
<query>dedup component | fields component | sort component</query>
</search>
</input>
</fieldset>
<row>
<panel>
<table>
<search base="baseSearch">
<query>search $sourcetype$ $component$</query>
</search>
<option name="drilldown">cell</option>
</table>
</panel>
</row>
</form> If that doesn't help, let me know what I misunderstood, and I'll be happy to update my answer.
... View more