Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Order Management Infrastructure Guide > PSP Engine > About Tuning Performance of PSPConsider the following when tuning the performance of your preconfigured and custom PSP procedures: Preconfigured PSP ProceduresTune the preconfigured PSP procedures by:
General Design GuidelinesFollow these general design guidelines to further improve the performance of PSP:
SQL QueriesUse the following guidelines to improve the SQL query performance of PSP:
Logging of PerformancePSP provides extensive logging of performance-related data. Analyze the PSP log to determine which steps are consuming the most processing time and where the caching can be further optimized. PSP logging that takes place in the server environment is more effective than PSP logging that takes place locally, because in the server environment there is only one environment variable controlling the log level for all the events. You can use the events listed in Table 23 to log the performance of PSP.
When debugging the pricer, the price waterfall output provides valuable clues as to which transforms and actions were executed. For more details on logging, see About Logging of PSP. Siebel PSP Cache is a mechanism designed to improve performance of PSP transforms. PSP Look-Up transforms use caching to reduce the number of SQL statements executed by the database. The cache stores the results of PSP Look-Up transform queries. The cache key is the business object, the business component, the search specification, and the sort specification. The PSP Cache of query results is shared across all user sessions on an Object Manager. A particular query is issued only once for each Object Manager and then shared by all users. This sharing maximizes the probability of a cache hit and improves performance and scalability for all users on the server. Transforms Involving Database QueriesOf all the PSP methods (transforms) provided by the Row Set Transformation Toolkit business service, those that involve database queries are the following: There are two ways that PSP Cache is implemented: one is special for the Dynamic Look-Up transform, and the other is for the rest of the transforms:
The following topics contain more information about PSP Cache: |
![]() ![]() |
Siebel Order Management Infrastructure Guide | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |