Performance Optimization for DataStore Objects 

In order to have good loading performance for DataStore objects, we recommend being aware of the following:

...

       1.      Creating SID values

The creation of SID values takes a long time and can be avoided in the following cases by:

¡        The indicator Creation of SID Values should not be set if you are using the DataStore object only as data storage. If you do set this indicator, SIDs are created for all new characteristic values.

¡        If you use line items (for example, document number or time stamp) as characteristics in the DataStore object, in the characteristic maintenance, indicate these as Attribute Only.

SID values are created in parallel if parallel activation is switched on (see last point). They are then created with the same number of parallel processes as created for the activation.

       2.      Partitioning  or clustering in active data tables (A tables)

By partitioning or clustering by database level, you can delete data from the DataStore object much more quickly. As a partitioning/clustering criterion, choose the characteristic by which you want to delete. You can find more information under Partitioning and Multi-Dimensional Clustering.

       3.      Indexing

Use selection criteria for queries for DataStore objects. If the key fields are specified, the existing primary index is used. The more frequently accessed characteristic should appear on the left-hand side.

If you did not specify the key fields completely in the selection criteria (visible in the SQL trace), you improve the run time of the query by creating additional indexes. You can create these secondary indexes in the DataStore object maintenance.

       4.      Runtime parameters of DataStore objects

To improve the performance when processing data in the DataStore object, you can make a number of settings for each DataStore object in the runtime parameters or maintain general default values for DataStore objects. You can maintain the runtime parameters either in Customizing under SAP Customizing Implementation Guide  ® SAP NetWeaver  ® SAP Business Information Warehouse  ® Performance Settings  ® Maintain Runtime Parameters of DataStore Objects or in the Administration area of the Data Warehousing Workbench under Current Settings ® DataStore Objects.

You can define the following:

Parameters for Activation:

¡        the minimum number of data records for each data package when activating data in the DataStore object, meaning you define the size of the data packages that are activated

¡        the maximum wait time in seconds when activating data in the DataStore object. This is the time when the main process (batch process) waits for the process that is split before it classifies it as having failed.

Parameters for SID Creation:

¡        Minimum number of data records per data package for SID creation in the DataStore object

¡        Maximum wait time in seconds when creating the SID in the DataStore object

Parameters for Rollback:

¡        Maximum wait time in seconds for rollback in DataStore object

Process Parameters:

¡        Type of processing: serial, parallel (batch), parallel (dialog)

¡        Maximum number of parallel processes

¡        Server group to be used when processing of the data in DataStore objects in parallel You must first create the server groups with: SAP Easy Access  ® Tools  ®   Administration  ®  Administration  ®  RFC Destinations  ®  RFC Groups. If you do not specify anything here, then processing runs on the server on which the batch process was started for activation. If a server from the server group is not active, then processing is cancelled.