RPAS Performance: Measure Calculation Time Appears to be Dependent on Domain Size and Not Workbook Size (Doc ID 549134.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Predictive Application Server - Version 13.0 to 13.2.3 [Release 13.0 to 13.2]
Information in this document applies to any platform.
checked for currency on 13/10/2010


Goal

The RPAS calculation speed appears to depend very much on the total size of the domain, whereas it should depend on the size of the workbook.   Assuming equivalent calculations, a workbook containing 50 items should exhibit similar calculation times, whether it is in a domain containing 500 total items or one containing 20,000 items.

Please see the results of our tests:
Case 1, Domain A:  17909 items, Workbook: 50 items.   Calculation time 8.1 seconds
Case 2, Domain B:  249 items, Workbook: 50 items.   Calculation time 3.4 seconds
Case 3, Domain A:  17909 items, Workbook 1 item.  Calculation time 7.9 seconds

The calculation times for the larger domain are over twice as high as those in the smaller domain, although the workbooks are of the same size (cases 1 and 2).  Furthermore, a workbook built in the large domain to contain only a single item exhibits a high calculation time, as well (case 3). 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms