Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Apr 14 at 7:29 AM Hi, (I'm not a master, but I've done some stuff with regards to performance in my company)
I have a few questions for you:
1. have you tried the same query using se16? How long does it take there? (se16 is a good time approach)
2. how many rows does your FAGLFLEXA hold? (you see, in my company this table is not enabled)
3. have you tried running that code with st05? Where do you find the program's wasting time?
BTW: If I'd have to work with this performance issue, I'd do a few minor changes: a. use a hashed table (or.. a couple of hashed tables). b. remove that sum and group by, change it with a collect or some code that simulate a collect. c. try working with an index whenever possible (how to do that? specifying the fields in the index in the where clause of that select).
HTH
Horacio
| | | ---------------Original Message---------------
From: emohtadi
Sent: Tuesday, April 14, 2015 2:38 AM
Subject: Performance Issue FAGLFLEXA
Hi Masters,
How to select the data efficiently for the table FAGLFLEXA?
This is my query:
Executed time is about 10 minutes.
SELECT-OPTIONS:
s_hkont for faglflexa-racct,
s_prctr for faglflexa-prctr,
s_date for bkpf-budat.
data begin of pre_h OCCURS 0.
data racct type faglflexa-racct.
data prctr type faglflexa-prctr.
data hsl type faglflexa-hsl.
data rwcur type faglflexa-rwcur.
data end of pre_h.
select racct prctr sum( hsl ) rwcur into table pre_h
from faglflexa
where racct in s_hkont
and prctr in s_prctr
and budat < s_date-low
and drcrk = 'H'
and rldnr = '0L'
group by racct prctr rwcur.
Best Regard. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
