Showing posts with label Clarity Performance. Show all posts
Showing posts with label Clarity Performance. Show all posts
Monday, August 29, 2016

Step By Step Approach To Increase the performance of the report.

›
·          Server Tuning o    Disk – IO Stat o    RAM -VMStat o    CPU - Top ·          Instance Workload Tuning o    Parameters...

Process Performance - CA PPM - Process Engine Maintanence

›
For oracle run SHRINKS on NMS_MESSAGES daily - often those tables get heavily fragmented due to bulk imports. when that happens, they gro...

Gel Script Performance - CA PPM - Process Design

›
Create multiple generic process XOG users Process XOG users would be restricted to just the rights required for the their particular ar...

Gel Script Performance - CA PPM - Avoid Excessive use of the Core:Set

›
In complex GEL scripts that build XOG XML from SQL query output, avoid excessive use of the <core:set> tag for performance reasons. T...

Gel Script Performance - CA PPM - Util Sleep

›
Avoid using <util:sleep> in GEL script. This tag puts the thread executing the GEL Script to sleep. There are only 12 GEL threads all...
Sunday, August 28, 2016

SQL Performance - CA PPM - Union Queries

›
UNION queries perform poorly as they can scan through the same data multiple times. Require any logic changes to be made in multiple loc...

SQL Performance - CA PPM - Distinct vs Exists

›
Both methods are commonly used to derive the unique values for dimension keys of portlets. EXISTS are preferable to DISTINCT. DISTINCT ...

SQL Performance - CA PPM - In vs Exists

›
IN is typically better when the inner query contains a small result set SELECT SRMR.FULL_NAME FROM SRM_RESOURCES SRMR WHERE SRMR.ID (SE...

SQL Performance - CA PPM - OBS Filtering

›
Seen many ways to filter based on OBS Many rely on complex logic, left joins to inline views, or multiple sub-queries. Using EXISTS and...

SQL Performance - CA PPM - Restrictive Conditions

›
 Begin queries with the most restrictive conditions SELECT SRMR.FULL_NAME, AV.SLICE_DATE,AV.SLICE FROM SRM_RESOURCES SRMR JOIN PRJ_BLB_S...

SQL Performance - CA PPM - Sub Queries

›
Sub Queries can be handy Sub queries are good in some situation but not all situation How many projects is a resource assigned to SEL...

SQL Performance - CA PPM - Unnecessary Joins

›
Remove unnecessary tables from queries Avoid falling back on common tables INV_INVESTMENTS SRM_RESOURCES Query to find role all...

SQL Performance - CA PPM - Using Table Aliases

›
Using Table Aliases Improves readability of SQL Use meaningful table aliases SELECT A.ID FROM SRM_RESOURCES JOIN ODF_CA_RESOURCE B O...