Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

doubt

Former Member
0 Likes
770

how to know how much time does a query takes in a program ?

In ST05, am not able to find my query and its execution time exactly.

Regards

Rajaram

6 REPLIES 6
Read only

Former Member
0 Likes
753

hi Raja Ram,

use tcode SE30 to measure the time.

<b><i>reward points if useful</i></b>

chandra

Read only

Former Member
0 Likes
753

Hi,

Goto se38, put ur program name, in the menu, goto Program --> Execute --> Runtime Analysis.

Regards,

Himanshu

Read only

Former Member
0 Likes
753

use run-time analysys. tcode is se30.

Read only

Former Member
0 Likes
753

You can get these details from SQL trace ST05.

Switch on trace before u execute your code.

after finishing switch off trace and display.

It will show you the time taken in microseconds

Read only

hymavathi_oruganti
Active Contributor
0 Likes
753

u can check it in se30.

Read only

Former Member
0 Likes
753

Hi,

use this,

*******************************************************************************************

get run time field t1.

do p_entry times.

read table t_stdtab into wa_stdtab with key int_val = p_entry.

enddo.

get run time field t2.

t3 = t2 - t1.

format intensified off color = 4.

write :/'TOTAL TIME FOR read with key in standard table:',t3.

*******************************************************************************************

<b>reward points if useful.</b>

regards,

Vinod Samuel.