SPPFP: Performance during selection (background mode)

[] [] []

Related:

  1. DB2/390: Performance of the updateSymptom The response time during transactions which use the asynchronous...
  2. DB2-z/OS: Performance Problems with DB2 V8/V9 REOPT(ONCE)Symptom This note will list all known SQL statements that...
  3. DB2-z/OS: Bad performance in method READ_SR_ACTIVITYSymptom DB2 is not using multiple index operation for the...
  4. BWA 7.00: Analyzing write performanceSymptom You find that indexing in SAP NetWeaver BW Accelerator...
  5. Search performance problem in the SAP Records managementSymptom When the customer performs a search on an element...
  6. AS/400: Performance settings for R/3Symptom AS/400: Setting system values for R/3 and BW operation...
  7. Performance improvement of report RSADRQU3Symptom Performance problem with report RSADRQU3. Other terms BAS_PERFORMANCE BAS_REGIONALSTRUCTURE...
  8. SAP BusinessObjects Explorer Performance & ReliabilitySymptom SAP Note 1366180 “SAP BusinessObjects Explorer PERFORMANCE & RELIABILITY”...

Symptom
You want to use the report RSPPFPROCESS (transaction SPPFP) to process actions; processing takes place in the background, indicator: Processing Without Dialog.
The selection of the actions takes a long time.
Other terms
RSPPFPROCESS, SPPFP, background mode, SELECT ORDER BY PRIMARY KEY
Reason and Prerequisites
During “Processing Without Dialog”, the actions to be processed are selected and processed in packages and sorted according to their primary key. This selection may take a long time.
Solution
On the selection screen, specify an additional variant for sorting the actions. In this case, the system does not select the actions in packages, but only once (the addition ORDER BY PRIMARY KEY is removed). This should speed up the selection of actions. However, it requires more main memory because a larger number of actions must be retained in the memory.
If a variant for sorting is not yet available, create a new variant as follows:
Use any criteria to select several actions in dialog mode (the indicator “Processing Without Dialog” is initial).Use the function “Save Layout (Ctrl+F10)” to create a new sorting variant (it is not relevant whether or not sorting is actually carried out in this variant).Use this variant for processing your actions in the “Processing Without Dialog” mode.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment