topic Re: abap report performance in Application Development and Automation Discussions

abap report performance

Former Member — Fri, 01 May 2009 15:48:16 GMT

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,

Re: abap report performance

HermannGahm — Fri, 01 May 2009 17:03:23 GMT

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

Re: abap report performance

Former Member — Sun, 03 May 2009 06:34:31 GMT

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.

Re: abap report performance

Former Member — Mon, 04 May 2009 11:38:12 GMT

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,

Re: abap report performance

HermannGahm — Mon, 04 May 2009 12:55:40 GMT

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

Re: abap report performance

Former Member — Thu, 07 May 2009 20:41:53 GMT

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