You want to analyze the database access times for a query that you defined based on a MultiProvider. You want to know which of the relevant InfoProvider caused the longest database access times.
The analysis portrayed here is only suitable for smaller application scenarios. If the existing dialog processes are not sufficient to execute all the subqueries at the same time, the remaining subqueries are executed at a later time. In this case, the information below does not apply. Six dialog processes are available as standard.
The statistics level is set to 2 for the required query: The system records all data from the area for the front end and calculation layer, as well as data from the area for the aggregation layer and aggregation information.
To analyze the statistics data, you have the following options:
Aggregated Statistical Data
000009000 |
Data Manager |
2,801470 |
0 |
000009010 |
Total DBTRANS |
0,000000 |
831 |
000009011 |
Total DBSEL |
0,000000 |
104.264 |
Detailed Statistical Data
The detailed statistical data provides a view into the execution of MultiProvider queries:
The access count 0 is the main process that the queries are split from.