Logging of Performance

PSP 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 the following table to log the performance of PSP.

Event Type	Alias	Description
Object Manager Business Service Operation and SetErrorMsg Log	ObjMgrBusServiceLog	Logs the performance of business service methods which include the PSP transform methods.
Workflow Performance	WfPerf	Logs the performance at the workflow level or step level.
PSP Cache Event For more information, see Logging of Performance.	PSPCache	Logs the performance of PSP Cache.

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.

About PSP Cache

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.