Stop Query from running on dropdown list

So I have 300 dropdown lists which are all pulling from the same mysql table. The issue I am having is its taking about 2 and half minutes to get them populated with the data. My question is there a way to have each dropdown list only query when a certain event happens? Like if I push a button then start querying the table with the specific dropdown. I hope I am making sense.

Some questions:

  1. What version of Ignition are you using?
  2. Are you using vision or perspective?
  3. How are the dropdowns “pulling from the same mysql table” now?
  4. Are the dropdowns displaying different information from the same table or the same info?
  5. Does the data in the dropdowns change often (perhaps based on other selections) or is it static?