Hi Everyone
Central Park v1.86.4050.11915 (26 August 2020) introduced a feature called Database Views to improve performance of functionality whereby large datasets are queried.
When configuring a Database View, the system will create and Indexed View in the database with data for the last {x} days, improving the performance where the user does not need to query the entire history of Transaction.
This can be configured as follows:
1. Transaction View & Instruction View
a. Navigate to Setup > Domains > Database Views tab
b. For each page, there is an individual option to configure
i. ValueDate range to include (days) - eg. 30 will lookup data for the last 30 days.
ii. Recreate view daily at hour (0-23) - will schedule a service to run daily in order to update the view. This should be configured after business hours.
iii. The view will be (re)created at the time of changing the configuration.
c. When enabled, the Transaction View & Instruction View pages will restrict searches up to the last {x} days as per the configuration. The user will be able to check the option to "Display data older than {x} days" if they need to query older data which will temporarily disable the Index View for that user until the page is reloaded.
2. Duplicate Validations
a. Database Views can be toggled on individually on the Duplicate Validation Configuration by capturing the Recreate view daily at hour (0-23) field. The data range will be based on the Value Date is within {x} days value.
3. Forcing a View to Recreate.
A Database View can be recreated on an ad hoc basis by accessing Setup > Database Views.
Detailed explanations have also been provided in the respective configuration pages.
Regards
The Central Park Team
No comments:
Post a Comment