At DWS, application performance is a fundamental part of software quality. We design and deliver code with performance in mind, ensuring that applications process their tasks efficiently and make responsible use of shared system resources.
In an enterprise environment such as JD Edwards EnterpriseOne, poor performance does not affect only the individual application or user. Slow-running processes can consume database and Enterprise server resources, reducing system performance for everyone.
This is particularly important for scheduled batch applications, known in EnterpriseOne as UBEs. Nightly jobs may gradually take longer as transaction volumes increase. Eventually, they can extend into normal business hours, delay other scheduled processes or interfere with database backup windows.
Common code-related causes of poor performance include:
- Inefficient algorithms or business logic
- Poorly optimized SQL queries
- Missing or incorrect database indexes
- Excessive database calls
- Unnecessary data processing or conversions
- Retrieving unnecessarily large result sets
- Inefficient loops or repeated operations
Oracle continues to invest in improving the performance and efficiency of EnterpriseOne. For this reason, customers should remain code current and take advantage of the latest fixes, optimizations and platform improvements. However, these improvements do not apply to custom code, which is often the source of performance issues.
At DWS, we have extensive experience in improving the performance of existing applications and UBEs. By analysing generated logs and, where necessary, using database diagnostic tools, our developers can identify the causes of poor performance, recommend appropriate changes and implement targeted improvements.
Depending on the application and the underlying issue, processing times can be reduced by as much as 90%, improving application responsiveness, batch-processing capacity and the overall stability of the EnterpriseOne environment.
