Skip to Content
0
Former Member
Nov 12, 2009 at 10:39 PM

Script Logic Performance Options NW SP4 - *GO, *COMMIT_EACH_PERIOD?

23 Views

Hello everyone,

I've created some script logic in SP4. The good news is that it works, but the bad news is that it's not as fast as I would like, especially since it will reside in default logic. That being said, the trick with this logic is that anytime data is loaded for certain accounts, it needs to recalculate values from the first period of the budget, push a value to the next sequential period, calculate again at that period, push a value to the next period again, etc...

So, I've got some *WHEN's, *LOOKUP's, and *COMMIT's to get the job done, but I feel like I have too many commits to have decent performance. In the SQL version, I would have used *GO's or other commands to shorten the code and/or do this quicker, but I don't feel like I have as many options in Netweaver SP4. Anything I'm missing out there folks?

Thanks,

Grant