Arvind Balakrishnan (Arvind)
BNYMellon Technology

BNYMellon Technology
Arvind Member since 2013 59 posts
BNYMellon Technology
Posted: March 6, 2017
Last activity: March 6, 2017
Posted: 6 Mar 2017 9:36 EST
Last activity: 6 Mar 2017 19:25 EST

Slowness in Portal load.

We are facing slowness when our portal loads. When traced we found that "Following Cases" section triggers a SQL ( D_pxfavorites thru RD pyFollowedCases in section Data-PortalpyPortalNav under harness Data-PortalpyCaseManager7).

The SQL formed for our portal is

SELECT "PC0".PYID AS "pyID", "PC0".PYLABEL AS "pyLabel", "PC0".PZINSKEY AS "pzInsKey" FROM PRPC_71SDS_pool.pccs_work "PC0"
INNER JOIN PRPC_71SDS_pool.pc_index_workparty "Party"
(( ( ("PC0".PZINSKEY = "Party".PXINSINDEXEDKEY) ) AND ("PC0".PXOBJCLASS LIKE 'MellonFinCorp-GCM-CSWork%') AND ("Party".PXOBJCLASS = 'Index-WorkPartyUri') ) ) WHERE ( ("Party".PXPARTYROLE = 'Follower') AND ("Party".PYPARTYIDENTIFIER = 'XBBJ293') ) AND ("Party".PXINDEXPURPOSE = 'PartyURI')

Though this returns 0 results it takes 10-15 mins to execute.

  1. Count of PRPC_71SDS_pool.pccs_work is 1598483
  2. Count of PRPC_71SDS_pool.pc_index_workparty is 16563939

Is this because of the count we have DB performance issue? I am sure there are applications with much more records and do they face this issue?? Since these are all OOB and help or suggestion will be appreciated.

System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.