‎2007 Oct 19 6:58 AM
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
‎2007 Oct 19 7:01 AM
hi Raja Ram,
use tcode SE30 to measure the time.
<b><i>reward points if useful</i></b>
chandra
‎2007 Oct 19 7:02 AM
Hi,
Goto se38, put ur program name, in the menu, goto Program --> Execute --> Runtime Analysis.
Regards,
Himanshu
‎2007 Oct 19 7:02 AM
‎2007 Oct 19 7:03 AM
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
‎2007 Oct 19 7:08 AM
‎2007 Oct 19 7:21 AM
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.