Supply and Demand (P4021) Performance

Hi there,
We are in 8.10 non-web and have recently started to have serious performance issues in supply and demand, where the time to look up one part takes an 4-5 minutes.
We have purged data recently, defragged indices in the database, but that has helped very little.
The SARS that are posted for Supply & Demand (which may or may not help) require installing huge ESUs which touch 300+ objects.
Can anyone offer any other tips on performance improvement for S&D?
We are on version EnterpriseOne 8.10 tools 8.96.2.2, windows 2003, sql 2000

Thanks.

My suggestion is for you to turn on debug, and run a single lookup. The debug will tell you exactly where the time is being taken - and it might indicate a SQL Select that is performing a full table scan (therefore you would need to create a custom index on that table).

Adding to what Jon suggested, have you added any new security records?

Our company did extensive analysis on this application for XE. We also are running an 8.12 instance and eventually did a ER compare. In the end, a consultant rewrote the XE application using the logic from 8.12. 8.12 essentially moved processing to business functions, specifically cache files. Probably not the most efficient solution but it works for our customers.