Skip to Content
0
Former Member
May 09, 2008 at 12:34 AM

runtime analysis time taken to access database is more

39 Views

hi all,

there's a custom transaction (for a program) which takes more than 2- 3 minutes when i executed it in prod.

sometimes more than 15 mins when someone else executed..not sure about this.

when i debugged the program i see there is a form which has more than 10 select statemnets and this form takes more than 1 min i just calculated when debugging...

i dont see nay peculiar select here.

any sugesstions pls,

see below for some select

SELECT PARTNER ADDRNUMBER

FROM BUT020

INTO TABLE X_MBUT020

FOR ALL ENTRIES IN X_NOTIF

WHERE PARTNER EQ X_NOTIF-KUNUM.

SELECT ADDRNUMBER HOUSE_NUM1 HOUSE_NUM2 STREET CITY1 POST_CODE1

FROM ADRC

INTO TABLE X_MADRC

FOR ALL ENTRIES IN X_NOTIF

WHERE ADDRNUMBER EQ X_NOTIF-ADRNR.

SELECT ADDRNUMBER HOUSE_NUM1 HOUSE_NUM2 STREET CITY1 POST_CODE1

FROM ADRC

APPENDING TABLE X_MADRC

FOR ALL ENTRIES IN X_MILOA

WHERE ADDRNUMBER EQ X_MILOA-ADRNR.

SELECT ADDRNUMBER HOUSE_NUM1 HOUSE_NUM2 STREET CITY1 POST_CODE1

FROM ADRC

APPENDING TABLE X_MADRC

FOR ALL ENTRIES IN X_MBUT020

WHERE ADDRNUMBER EQ X_MBUT020-ADDRNUMBER.

DELETE ADJACENT DUPLICATES FROM X_MADRC.

other select are also similar to these but different tables and itabs..

2) Also i got the list of gross time,net time etc from SE30 and not very sure on how to use it.

need an overall idea about this list which runtime analysis gives us.

14.280.671 = 14.280.671 21,9 21,9 Fetch ADRC

4.294.967.295 -1 0,0 0,0 Close Cursor TPAUM

i justed pasted 2 lines from that