Optimizing Performance for All Source Transactions

To optimize budget processor performance for all applications that you have enabled to feed source transactions into budget processor:

  1. Recompute statistics for these tables when the row count of these tables exceeds 3,000 rows. If the row count is less than 3,000, then delete statistics from the tables.

    1. PS_LEDGER_KK

    2. PS_KK_SOURCE_LN

  2. Recompute statistics for the PS_KK_SOURCE_HDR table when the row count exceeds 10,000 rows.

    If the row count is less than 10,000 rows then delete statistics from the table.

  3. Recompute statistics on the Product KK_SOURCE_HDR table if the row count exceeds 10,000 rows. . The table name can be found on the Source Transaction page in the KK Source Header Record field as depicted below.

    This example illustrates the fields and controls on the Source Transactions - Definition page.

    Source Transactions - Definition page

    Note:

    If the row count is less than 10,000 rows, you can delete statistics from the table.

  4. Delete statistics from PS_BP_CF_TAO.

  5. Delete statistics from PS_BP_XCF_TAO, and PS_BP_XCF2_TAO.

  6. Analyze SYS scheme tables (all system tables) to improve parsing time.

  7. Add these indexes:

    Table Index Index Fields

    PS_GL_ACCOUNT_TBL

    PSFGL_ACCOUNT_TBL

    SETID, STATISTICS_ACCOUNT, EFF_STATUS, ACCOUNT_TYPE, ACCOUNT, EFFDT

    PSRECFIELD

    PSGPSRECFIELD

    RECNAME, SUBRECORD, FIELDNAME, FIELDNUM, CURCTLFIELDNAME, USEEDIT

    PSTREELEVEL

    PSBTREELEVEL

    SETID, TREE_NAME, TREE_LEVEL, EFFDT, TREE_LEVEL_NUM

    PSTREENODE

    PSGTREENODE

    (1) TREE_NODE, SETID, TREE_NAME, EFFDT, TREE_NODE_NUM

    (2) SETID, TREE_NAME, EFFDT, TREE_NODE_NUM, TREE_NODE_NUM_END

    PSTREELEAF

    PSCTREELEAF

    SETID, TREE_NAME, EFFDT, RANGE_FROM, RANGE_TO, TREE_NODE_NUM

  8. Update statistics on these tables: PSTREELEVEL, PSTREENODE, PSTREELEAF.

See also PeopleTools: PeopleSoft Application Designer

Related Topics