R GUI Performance Enhancements

This appendix describes how you can improve the performance of the Reporter user interface by increasing the Degree of Parallelism (DOP) setting.

R.1 Introduction

Within the Reporter user interface, the performance of queries (such as refreshing a dashboard or retrieving data within the Data Browser) is heavily influenced by the specified Degree of Parallelism (DOP) setting. This regulates the maximum number of parallel queries that may be made to the database. By default, this is two. In the case of deployments where the Reporter system has substantially more CPUs than this default, or where a dedicated database server is being used, a considerable user interface performance improvement can be realized by increasing the DOP setting.

R.2 Modifying the DOP Setting

The DOP is controlled by the dp_gui_dop entry within the uxs_config table. Upon installation, this entry does not exist in the database. Do the following:

1. Logon to the Reporter system, and issue the following commands as the root user:

   # su - moniforce
   # sqlplus /@uxinsight
   

2. To assign an initial value to the DOP, issue the following commands:

   SQL> INSERT INTO uxs_config (ID,CATEGORY,NAME,VALUE,OPTIONS) values(uxs_config_seq.nextval,'wi_core','db_gui_dop','N','type=bool;');
   SQL> EXIT
   

   Alternatively, to modify a previously specified value, issue the following commands:

   SQL> UPDATE UXS_CONFIG SET VALUE='N' WHERE NAME='db_gui_dop'
   SQL > EXIT
   

   where N specifies the degree of parallelism used for queries within the Reporter interface. Note that this should be less than the number of cores within the database system.