abap report performance

[Former Member]

Hi,

We are in the process of archiving data ( payroll clusters) on our system. During the testing of a program with archiving and without archiving, I was analyzing the performance of a custom report that fetches the data from payroll clusters. I had a queston related to it.

The impact on the database in the archived environment was drastically reduced as compared to the performance of the report in the non archived set up rightfully so. I got it. However the the execution time on the 'ABAP' program was more in the archived set up as compared to the execution time of the same in the non archived one. I did not understand this. Can anyone help me understand this?

I used SE30 (run time analysis) tool for my analysis.

Thanks in advance,

VG

[HermannGahm]

Hi Vinu,

> I used SE30 (run time analysis) tool for my analysis.

... and? what did you find out? Where is your time spent?

database access? or something else?

Have you measured BOTH executions... on the archived environment and

the non archived environment to find out the difference?

Without more information there is not much left to tell you... .

The only thing i experienced in similar problems (bad performance

after archiving) was related to not updated database statistics after

archiving... leading to non optimal execution plans... .

Kind regards,

Hermann

[Former Member]

you must tell us the absolute numbers, especially because many people compare percentages in this forum, and ABAP % will clearly increase if DB % go down.

[Former Member]

Hi,

In the archived environment, the ABAP % increased from 20% to 60%, as compared to the non archive environment, where the DB was around 65% and ABAP % was 20. I did not understand the correlation to why ABAP% increases under archive environment?

Thanks,

VG

[HermannGahm]

Hi Vinu,

these percentages are not very interesting.

> I did not understand the correlation to why ABAP% increases under archive environment?

SE30 shows you the distribution of the total runtime (100%) in ABAP time (x %), DB time (y %) and System time (z %). So that x + y + z = 100 %

When DB % goes down, Sytsem % remains the same ABAP % has to go up, right?

To help you we need the absolute figures, as Siegfried already mentioned. Please go to the hit list for both traces and post the resutls here... then we can tell you further steps...

Kind regards,

Hermann

[Former Member]

Thanks alot. I understood the equation. It makes sense now.

VG