Using the Request Summary Table for Improved Dashboard Performance

This article explains how to use the Request Summary Table to improve the performance of your Dashboard.

Understanding the Request Summary Table

The Request Summary Table is a new feature that optimizes Dashboard performance by storing a summarized version of received requests. This table contains less detailed information than the standard request table, resulting in fewer records and faster queries.

Enabling the Request Summary Table

To enable the Request Summary Table, you need to install the "System" module. This will initiate the data loading process, which runs in the background and takes approximately 30 minutes per million requests.

Monitoring the Data Loading Process

You can monitor the data loading process by checking the Operation Log. The log updates every 10,000 requests, displaying the progress and the total number of requests loaded. Once the process is complete, the log will indicate the total number of requests loaded and the total time taken.

Using the Request Summary Table

Once the data loading process is complete, your dashboards will automatically start using the Request Summary Table. This is indicated by the "USE_REQUEST_DW_TABLE" parameter in the "System" module, which will be set to "1" at the end of the loading process. You can revert to the previous Dashboard data source by setting this parameter to "0". To achieve this, follow the steps below:

1. Navigate to SUPERADMIN OPTIONS > System > Parameters.
2. Locate the USE_REQUEST_DW_TABLE parameter and click on UPDATE.
3. Add the value 0 in Value S.

Important Notes

• Requests received during the data loading process will not be lost and will be loaded once the process is complete.
• The "System" module installation requires administrator privileges.

Installing the "System" Module

To install the "System" module, follow these steps:

1. Log in to Globant Enterprise AI Backoffice as system administrator.
2. Navigate to SUPERADMIN OPTIONS > System > System Modules.
3. Locate the "System" module and click on Install/Update.
4. The module will begin the migration process in the background. While the module will indicate that it has been updated, you need to check System > Operation Logs for a summary of the migration. This summary will indicate whether the migration was successful.