‎2008 Jun 02 8:13 PM
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
‎2008 Jun 02 8:19 PM
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
‎2008 Jun 02 8:19 PM
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
‎2008 Jun 03 2:05 PM
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