Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-WHM-DBA (Application Component) Data Basis⤷
RSR_CORE (Package) Processor for Core Objects Reporting
Basic Data
| Data Element | RSRPERSISTMODE |
| Short Description | Cache Persistence Mode |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | RSRPERSISTMODE | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Pers. Mode |
| Medium | 16 | Persistence Mode |
| Long | 20 | Persistence Mode |
| Heading | 16 | Persistence Mode |
Documentation
For specific active cache modes (Main Memory Cache with Swapping, Persistent Cache per Application Server, and Cross-Application Server), you can define how the displaced or cached data is to be stored. You can select the following persistence modes:
- Inactive: If you select this option, the system resets the cache mode to Main Memory Cache Without Swapping (1).
- Flat file: Storage in a file.
- Cluster Table: Storage in a non-transparent database table of type CLUSTER.
- Transparent Table (BLOB): Storage in a transparent database table with BLOB (Binary Large Object).
Compared to the Cluster Table, the Transparent Table (BLOB) leads to better system performance if you have large result sets. This is because fewer database operations have to be performed. With smaller result sets, the Cluster Table can be advantageous as BLOB fields require more administrative effort with regard to the database.
With these persistence mode settings, you can test which persistent storage gives the best performance in your system environment for each individual query.
If you do not define a persistence mode for the query, the persistence mode maintained as the default mode in Customizing is used for all the queries created for an InfoProvider.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 30A |
