topic Re: how to maintain a timer in Application Development and Automation Discussions

how to maintain a timer

Former Member — Mon, 02 Jun 2008 19:13:19 GMT

Hi,

in my program i am executing a set of select statements and i need to calculate the time taken to execute those. how to maintain a timer for this ? what statements to use ?

thanks

Re: how to maintain a timer

Former Member — Mon, 02 Jun 2008 19:19:06 GMT

This was Rob's replies in a similiar post:

You can do this:code

data: start TYPE i,

end TYPE i,

dif TYPE i.

GET RUN TIME FIELD start.

SELECT SINGLE bukrs belnr gjahr blart budat

FROM bkpf

INTO (cc, doc, fy, doc_ty, pst_dt)

WHERE bukrs = p_bukrs

AND belnr = p_belnr

AND gjahr = p_gjahr.

GET RUN TIME FIELD end.

dif = end - start.

WRITE: /001 'Time for select',

067 ':', dif, 'microseconds'.

[/code]Rob

Re: how to maintain a timer

Former Member — Tue, 03 Jun 2008 13:05:48 GMT

I don't have the original post in front of me, but I probably also said that you should do this a number of times and take the lowest time for comparison.

Rob