I know this is a common problem, however i am looking on how i can improvize the performances.
The system is slow & needs to be speeden for end users using the IP application whenever
-Opening planning template contains several accounts/profit centres
-tabbing from one cell to another
-executing planning sequences , esp sales planning.
is something like pre-calculating the queries with the already planned data will help improve performance?
assumming that not much changes i can make in the planning function at this moment when the system is live, what other options from the database can i do to improve performance.
any help , appreciable.