|Form Options Binder is used on form element such as Select Box to dynamically populate its selections.|
Joget v6.0.9 has a new feature to enhance the performance of Form Options Binder via a new caching option for large data set. You can see the following new field after selecting any "Options Binder" option:
|Sync Cache Interval|
How often to activate cache synchronization (in seconds).
For example, when set to 180 seconds, background synchronization in the server will take place every 180 seconds to refresh with new/latest data.
|Pause sync after idle|
How long to wait to pause synchronization after idle.
For example, this may be used in conjunction with User Option Binder to return all the users into a dropdown selection. If the users' records are large (in the ten of thousands), it is recommended to set the "Pause sync after idle" to a larger value and the sync will continue to update the cache in the background. If the dropdown selections are unlikely to change in a very short interval, it is recommended to set the "Sync Cache Interval" to a larger value too so that the server does not perform a new cache again in short span of time.