The number of database calls performed when large forms such as Global Settings are opened has been reduced

Certain forms within finPOWER Connect perform a large number of database queries.

Forms such as Global Settings perform a quick database call every time a DBCombo is populated to see if the corresponding global collection (e.g., Information Lists) needs refreshing.

All refreshable collections (e.g., global collections such as Scripts) now have a LastRefreshTime property that will return the date and time that the Refresh method was last called.

The functionality to populate a DBCombo has been updated so that if a refresh of the global collection has occurred in the past 10 seconds (2 seconds if the User has manually refreshed the form), then no database check will be performed. In the case of the Global Settings form, the reduces the number of database calls made by about 180.

Modal forms such as Global Settings were also refreshing their DBCombos twice. This double-up has been resolved.