Retail Merchandising System (MOSC)

MOSC Banner

In RMS 14.1, order search by order number (FM_ORDHEAD) seems slow

edited Apr 28, 2016 4:20PM in Retail Merchandising System (MOSC) 1 commentAnswered

We are doing some performance testing, and looking for tuning opportunities.  We are using a load program, and scripting access, to see what kind of load and response are encountered.


When doing the order lookup by order number, we noticed an odd behavior - the average response, for a single user, to access the screen if we select an order with a large number of items, is around 30 seconds.  The following test results are excerpted from our analysis.  Does it make sense that the same queries would be executed 2+ MILLION times in this scenario?  Is this just the cost of doing business, and looking up orders with a large number of rows, or are there areas we should look at to improve the response, here?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center