Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Sep 22 at 7:12 AM That time is important. Anyway, if you have to run it a few times a month, it isn't a big problem. Anyway, you can try your last bet. (if you can cut from 5500 seconds to 300 or even to 600... you have a great gain of time.)
ALV grid is a matter of displaying data. It has nothing to do with retrieving data which in fact was the point I was going after.
Good Luck.
| | | ---------------Original Message---------------
From: joeelf
Sent: Tuesday, September 22, 2015 12:25 AM
Subject: Multiple Key Hashed Table, Full Key of Next Table Vs. Select With Constants
The good news is that the longest runtime on this program was 5500 seconds last week, and with some minor adjustments (using a sorted table rather than standard for some of the big data and adjusting the READ in a loop to use the key better) it is down to 1100 seconds today (with the same criteria).
One of the other enhancements was a newer ALV grid, which is still rather pointless for any runs over 5-10 minutes in my opinion. The users need to be able to sort and filter and drilldown on the data online, requiring an even faster runtime.
I am guessing with hash tables this 1100 seconds may indeed be possible to run in 300 seconds (with dropping BKPF and MBEW, and doing a more selective read to EKKO & EKPO and KEKO + KEPH).
Best regards.
Joe |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.  _.____.__ |
