How To Improve Applet Performance In P6 When Working With Larger Datasets
(Doc ID 1397987.1)
Last updated on DECEMBER 03, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 22.214.171.124 to 126.96.36.199 [Release 8.1 to 17.12]
Information in this document applies to any platform.
The goal of this document is to provide instruction for improving applet performance in P6 Web when configuring the applets to load a larger dataset, by increasing the amount of maximum amount of memory which can be allocated to applets when loading in the user's web browser.
Applets in the P6 EPPM application include areas such as the Activity, EPS, Assignments, OBS, and User Administration views, as well as in various portlets which can be loaded on a dashboard.
When loading an applet in P6:
- If the progress bar says "Loading data…", it is waiting for the application server to return the data (most of that time being the SQL query time), and would not benefit from an increase in JRE Memory. If the performance issue is here, then the best course is to trace the Java statements to find the SQL SELECT statement generating the delay, using the instructions in How To Trace SQL And Java From The P6 Web Access Server (Doc ID 894429.1).
- If the progress bar says "Processing data…", it has received the data from the application server and is generating the tree in the applet in the browser using the Java Runtime Environment (JRE) on the workstation. At this time CPU usage can be seen on the workstation from the JRE's java.exe process. During this time, having a monitoring tool running (example: Java VisualVM which comes installed with a JDK) and viewing the java.exe process will show the current heap size and compare to the heap size on the Monitoring tab of the monitoring tool. If it remains very close to the maximum value and a lot of Garbage Collection activity is indicated in the CPU usage graph, performance would very liekly benefit from additional heap memory, following the instruction within this document.
NOTE: Java applets were completely removed starting with r18.8. This document is no longer applicable to P6 EPPM r18.8 and later release versions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!