topic Re: Drop-down selection is slow with large data in Dashboards & Visualizations

Drop-down selection is slow with large data

assadzakir — Tue, 13 Oct 2020 10:49:23 GMT

we have tons of unique records per day,
so when I'm querying for the last 15 or last 30 days the dropdown is getting slow down.

Is there any solution like that when I will "TYPE" for the record which is starting with the word "ADF" on the dropdown and it should auto-populate with only the top 3 or top 5 records?

or Is there any other way to fix this dropdown performance issue?

Re: Drop-down selection is slow with large data

gcusello — Tue, 13 Oct 2020 10:52:29 GMT

Hi @assadzakir,

there are many choices, the easiest is to schedule a night search that populates a lookup containing the values for the dropdown, then use the lookup in the dropdown search.

Ciao.

Giuseppe

Re: Drop-down selection is slow with large data

AntonyPriwin — Tue, 13 Oct 2020 11:11:34 GMT

Hello @gcusello ,

Hope you are doing good!

We tried the same by populating a lookup and querying from the lookup, as for a limited time range(e.g; last 5 days) we have nearly 6000 events flowing into the dropdown. For each click we need to wait for around 8 sec for the dropdown to show up. is there any other way to load the dropdown faster.

Thanks,

Antony

Re: Drop-down selection is slow with large data

gcusello — Tue, 13 Oct 2020 12:02:42 GMT

Hi @AntonyPriwin,

if you cannot have a limited list of values in the dropdown, you have only two choices:

replace the dropdown with a text box;
use two dropdowns in chan: using the first (e.g. showing ranges: A-C, D-G, H-N, O-S, T-Z) to filter out the second.

With the second you're not sure to have a quick list, so I hint the first.

Ciao.

Giuseppe

Re: Drop-down selection is slow with large data

ITWhisperer — Tue, 13 Oct 2020 13:43:31 GMT

You could use a text input to modify a multiselect dropdown - when the text is less than 3 characters set the filter to head 1 (to hopefully speed up the query), otherwise set it to an appropriate where clause.

<input type="text" token="keyprefix"> <label>Select a key prefix</label> <change> <eval token="prefix_choice">if(isnull('form.keyprefix') OR len('form.keyprefix')<3,"head 1","where like(key,\"".'form.keyprefix'."%\")")</eval> </change> </input> <input type="multiselect" token="key" searchWhenChanged="true"> <label>Select a key</label> <search> <query>query | $prefix_choice$ | dedup key | fields key</query> </search> <fieldForLabel>key</fieldForLabel> <fieldForValue>key</fieldForValue> <prefix>(</prefix> <valuePrefix>key ="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> <suffix>)</suffix> </input>