|
Solve. Once you have identified the
critical paths and possible causes, you will need to have tools to help
you solve the performance problems. Performance Management Plus
toolset gives you two powerful ways to solve common system performance
problems:
When your performance problems result from
poor database queries, better SQL will help tremendously. The
Performance Manager Plus Data Access APIs give your developers the
capability of creating better SQL statements than is otherwise possible
in EnterpriseOne. You can create better SQL statements that let
the database do the work that it should.
When your performance problems result from
poor redundancy management, better caching can be the solution.
For instance, if you repeatedly fetch the same set of rows from the
database, it would be much better to cache the rows and access the
redundant information from memory. This will improve both database
and network performance.
Test. Once you have
implemented your solutions, you can test the changes with the
Performance Monitor. The monitor will show how much you have
improved things. Also, you may see new critical paths that will
require additional solutions. Over time, you will cycle through
this process to guarantee ongoing performance.
Find more information on the
download page or contact us to set up a
demonstration.
|