Cache Data for Input Select and check box List

When implementing Input Select List and Input check box List elements that will be used frequently, and populating them with live data (rather than static options), you may want to use DataLayer.Cached to retrieve the data. This will limit the number of queries required.

If you must use a long-running SELECT DISTINCT query on a large table to populate the list data, set up a scheduled Process Task to refresh the cached data during off-hours.