Problem Note 68823: There are a larger number of database calls than expected when using SAS® Visual Investigator
 |  |  |  |  |
By design, when data is retrieved from the database, it is cached for one minute. After one minute, the data gets refreshed by new database calls when necessary. This step is resulting in additional database load.
A workaround is to adjust the refreshAfterWriteInSeconds setting in SAS® Environment Manager. To do this, navigate to Manage Environment ► Configuration ► Definitions ► sas.svi-datahub.cache.datastore. Click New Configuration if one is not already defined. Adjust the value for the refreshAfterWriteInSeconds setting to 600. This setting triggers refreshes to occur at every 10 minutes instead of after only 1 minute. Optionally, you can raise this value to an even higher number and also increase the value for the expireAfterAccessInMinutes setting.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After the hot fix is applied, a database call occurs only when the data has changed.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.7 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_7_home.html#68823An update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_7_home.html#68823| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-02-09 13:31:25 |
| Date Created: | 2022-01-21 15:47:25 |