topic Re: Performance Analysis in Application Development and Automation Discussions

Performance Analysis

Former Member — Tue, 14 Mar 2006 09:42:07 GMT

Hi,

I can test the performance of an ABAP Object using SE30.

Is there a way to change a few lines and test the new code in the same transaction rather than creating another and then testing?

Also using ST05, I get the following error when I press the Explain tab for the SQL statement:

DATA: lt_spfli type table of spfli.

select * from spfli into table lt_spfli

where carrid = 'LH'.

SQL errorcode 443-

<u>SQL Statement</u>

SELECT

REPLACE(REPLACE(SUBSTR(VARCHAR(DB2START_TIME),1,1

9),'.',''),'-','') FROM TABLE( SNAPSHOT_DBM ( 0

)) AS SNAP

<u>Error Text</u>

SQL0443N Routine "SYSPROC.SNAPSHOT_DBM" (specific

name "SNAPSHOT_DBM") has returned an error

SQLSTATE with diagnostic text "memory allocation

error". SQLSTATE=38553

Regards,

Rachita

Re: Performance Analysis

Former Member — Tue, 14 Mar 2006 09:45:47 GMT

Hi rachita,

paste your code in the 'TIPS AND TRICKS' of the runtime analysis..

there you can compare two codes

modify the code and run..

you can see the time difference immediately

regards

satesh

Re: Performance Analysis

Former Member — Tue, 14 Mar 2006 09:58:05 GMT

Hi,

That gives me an immediate analysis.

Don't know about the ST05 error yet.

Thanks,

Rachita

Re: Performance Analysis

Former Member — Tue, 14 Mar 2006 09:58:42 GMT

Hi,

You can test the parts of your code in the Tips and Tricks section where you can compare the two codes.

But other than that I think there is no way that you could simulatenously edit and measure performance.

For q2,

DATA: lt_spfli type table of spfli.

select * from spfli into table lt_spfli

where carrid = 'LH'.

I tried the same and didn't get any error.

Re: Performance Analysis

Former Member — Tue, 14 Mar 2006 10:02:56 GMT

Hi,

Use TIPS AND TRICKS in SE30.

paste your code without REPORT or PROGRAM statement

and execute.

Regarding the error, there is nothing much an ABAPer ca do as it is a database level error.

contact your BASIS admin.

Regards,

Shashank

Re: Performance Analysis

Former Member — Tue, 14 Mar 2006 10:03:35 GMT

Hi rachita,

the piece of code you gave doesn't give me any error

regards

satesh