topic Re: doubt in Application Development and Automation Discussions

doubt

Former Member — Fri, 19 Oct 2007 05:58:19 GMT

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

Former Member — Fri, 19 Oct 2007 06:01:55 GMT

hi Raja Ram,

use tcode SE30 to measure the time.

reward points if useful

chandra

Former Member — Fri, 19 Oct 2007 06:02:03 GMT

Hi,

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

Regards,

Himanshu

Former Member — Fri, 19 Oct 2007 06:02:18 GMT

use run-time analysys. tcode is se30.

Former Member — Fri, 19 Oct 2007 06:03:57 GMT

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

hymavathi_oruganti — Fri, 19 Oct 2007 06:08:52 GMT

u can check it in se30.

Former Member — Fri, 19 Oct 2007 06:21:54 GMT

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.

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

reward points if useful.

regards,

Vinod Samuel.