Siebel Order Management Infrastructure Guide > Product Selection and Pricing Engine > About Tuning Performance 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.

Transforms Involving Database Queries

Of all the PSP methods (transforms) provided by the Row Set Transformation Toolkit business service, those that involve database queries are the following:

• Simple Look-Up
• Query
• Hierarchical Look-Up
• Rule Set Look-Up
• Dynamic Look-Up

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.

• PSP Dynamic Look-Up Transform Cache. This cache is used when the Dynamic Look-Up transform performs a query. For more information, see About Using the PSP Dynamic Look-Up Transform Cache.
• PSP Generic Cache. This cache is used when all transforms other than the Dynamic Look-Up transform perform a query. For more information, see Using the PSP Generic Cache.

The following topics contain more information on PSP Cache:

• Enabling PSP Cache
• Setting Cache Size
• Using the PSP Generic Cache
• Optimizing PSP Cache
• Defining a Cache Refresh Key
• Configuring a Clear Cache Button
• About Using the PSP Dynamic Look-Up Transform Cache
• About PSP Cache Performance Statistics