Advance Pricing & Performance in SO Detail (B7331)

fsaeed

Member
B7331 SP7.1 /NT 4.0 SP 5.0/SQL 7.0 SP2.0 / Citrix MetaFrame 1.8
8 processor HP / 4G of RAM Enterprise box


We had JDE Tier 1 business consultants setup our advance pricing with the
following 6 layers of PRICING PREFERENCE HIERARCHY and about 42 schedules:

1). Item Number by Ship To Address
2). Item Group by Ship To Address
3). Item Number by Sold To Address
4). Item Group by Sold To Address
5). Item Number by All Customers (Base Pricing Only)
6). Item Group by All Customers (Base Pricing Only)

I am more tehnical than not. For what I have been told, these business
consultants have not seen such complex advance pricing. The only reason I
mention this is because these consultants specialize in advance pricing and
I am not questioning their expertise.

As we grow and add more users we have started to see the following advance
pricing performance issue:

o If we don't have advance pricing setup for certain customers with no one
on the system:(FAT or Terminal Servers)
P4310 - Adding one line and going from that line to a new line in the SO
detail takes less than 1 second.

o If we do have advance pricing setup for certain customers with no one on
the system:(FAT or Terminal Servers)
P4210 - Adding one line and going from that line to a new line in the SO
detail takes 3-4 second.

o If we do have advance pricing setup for certain customers with 100+ type
load on the system: (FAT or Terminal Servers)
P4210 - Adding one line and going from that line to a new line in the SO
detail takes 6-20 second (depending on the load).

I have searched the old JDElist/ New JDElist articles and have seen this
issue mentioned but no ideas about how to solve this problem. Someone did
mention that they are going to call the repricing UBE for advance pricing at
night. We cannot implement this solution for a lot of reasons.

We are pushing Denver to resolve this issue as soon as possible since 3-4
seconds per line is not acceptable out in the field.

My questions to the list are:

Are any of you doing complex advance pricing and how is your performance??
Have any of you heard of performance problems and/or solutions that I may
have missed??

Thanks in advance for any comments and suggestions....

Faisal
 
It was recommended to keep the number of levels in the hierarchy as low as
possible, 4 or less. I have seen significant performance improvements when
reducing the number of levels.

Steve Erickson
 
Hi,

There is 2 way of invistagation :

1) However the skill of the consultant who implemented the solution, you can
go for an audit and some simplification may be done (just base on the
statment that an external look put some things under light)

2) I had that problem and we solve it by adding a new logical file to
improve the file I/O's

Anyway, since u have 6 layers u will have some delay

regards

----- Original Message -----
From: "fsaeed" <[email protected]>
To: <[email protected]>
Sent: Monday, May 21, 2001 11:26 PM
Subject: Advance Pricing & Performance in SO Detail (B7331)


and
at
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
11298
 
This may be going in the wrong direction but were are your business functions mapped? We were having this problem with our system until we mapped our business functions to our Enterprise Server. After that we were getting about 1 second per line.

Hope this helps.



Chad Anderson
Generac Portable Products
B733.1 SP 7.1
AS400 DB2 Ent
NT SQL 7.0 Dep
Citrix M1.8 on NT 4.0 TSE
 
Back
Top