How to improve the performance of ARC application?

How to improve the performance of ARC application?

The resolution specified below is one among many, as the performance of ARC depends on several other aspects like Tomcat's memory settings, physical RAM etc. In cases where ARC is slow to be accessed, try adding the below-mentioned indexes into the admin db: CREATE INDEX idx_moduleid_001 ON ADMIN_MAP_DEP_ROLE_USER_PRIV(MODULE_ID); CREATE INDEX idx_maxlevel_001 ON ADMIN_MAP_DEP_ROLE_USER_PRIV(MAX_LEVEL); CREATE INDEX idx_module_001 ON ADMIN_KPI_GROUP_MODULE(MODULE_ID); CREATE INDEX idx_group_001 ON ADMIN_KPI_GROUP_MODULE(GROUP_ID); CREATE INDEX idx_kpi_001 ON ADMIN_KPI_GROUP_MODULE(KPI_ID); CREATE INDEX idx_kpi_002 ON ADMIN_KPIVIEWDETAIL(KPI_ID);

    • Related Articles

    • KPI grid takes longer time to load. How can I improve the performance?

      Enhance the following configurable properties in 'arc.properties' so that the KPI Grid is loaded faster: arc.datagrid.partly.size = 1000 arc.distributed.parsing.size = 20

    • The application performance is very slow

      a) Ensure that there are no KPIs or graphs trying to retrieve data and inturn the system went unresponsive b) Also check if there are any idle connections to the database. These idle connections should be deleted from database.

    • Why is the application performance very slow?

      Ensure the following: a. There are no processes running in the background. For example, some KPIs or graphs trying to retrieve data. b. Terminate idle connections to the database. These two cases can make your application run slower. This is advanced ...

    • Why is the performance of ARC slow sometimes?

      The performance of ARC depends on the aspects like Tomcat's memory settings, physical RAM and also the indexes etc, you can verify the indexes in the admin db as follows. Try adding the following indexes into the admin db: > CREATE INDEX ...

    • How can I delete a module from ARC application?

      There is no interface to delete a Module as there is inter-dependence between a KPI, KPI Group and Module. Alternatively, you can de-activate modules by making it Inactive from KPI Management section of administrator module. Once done, do re-cache ...