BBritain
VIP Member
Ladies and Gentlemen,
Our users are Customer Sales/Service Personnel who are on the phone with their customers constantly. On a 30 second call, they can review the prices of 12-20 different products on their current system. As they go to OneWorld they need the ability to have the advanced prices pop-up for any of their customers. Because advanced pricing can be down to the customer level, each and every item (20,000) must be priced for each and every customer (650) requiring 13 million calculations. I have cut my calculation process down to where I can process 4 calculations per second (most of that time is processing the advanced calculation).
I am looking for suggestions to speed up this process. Since we are running on an AS400 we are looking into RPG running the World Advanced Price Calculation function (We are NOT coexistent but do have a world license), or rewriting the OneWorld Advanced Price Calculation function trying to trim down the complexity but still meet our needs.
Does anybody out there have any experience they can share or any suggestions to try. Every time a Sale occurs they may change the price of a whole product line (~2-5000 items)which needs to be calculated before the calls begin bright and early in the morning. One process we are considering is when pricing changes are known in advance, that we calculate the prices in a backup table and copy the table during the night.
Any advice will be considered,
Ben again,
Our users are Customer Sales/Service Personnel who are on the phone with their customers constantly. On a 30 second call, they can review the prices of 12-20 different products on their current system. As they go to OneWorld they need the ability to have the advanced prices pop-up for any of their customers. Because advanced pricing can be down to the customer level, each and every item (20,000) must be priced for each and every customer (650) requiring 13 million calculations. I have cut my calculation process down to where I can process 4 calculations per second (most of that time is processing the advanced calculation).
I am looking for suggestions to speed up this process. Since we are running on an AS400 we are looking into RPG running the World Advanced Price Calculation function (We are NOT coexistent but do have a world license), or rewriting the OneWorld Advanced Price Calculation function trying to trim down the complexity but still meet our needs.
Does anybody out there have any experience they can share or any suggestions to try. Every time a Sale occurs they may change the price of a whole product line (~2-5000 items)which needs to be calculated before the calls begin bright and early in the morning. One process we are considering is when pricing changes are known in advance, that we calculate the prices in a backup table and copy the table during the night.
Any advice will be considered,
Ben again,