How To Improve Applet Performance In P6 When Working With Larger Datasets
Last updated on DECEMBER 05, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
The goal of this document is to provide instruction for improving applet performance in the P6 (web based application), 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 (on the workatation).
Applets in our 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 appserver 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 you would benefit from tracing the Java statements to find the SQL SELECT statement generating the delay, using the following knowledge base document: 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 appserver and is generating the tree in the applet in the browser using the Java Runtime Environment (JRE) on the workstation. At this time you would see CPU usage on the wokration from the JRE's java.exe. During this time if you have a monitoring tool running (example: Java VisualVM which comes installed with a JDK) and viewing the java.exe process, you can look at 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 max and you see a lot of Garbage Collection activity in the CPU usage graph, it’s a good bet it could benefit from more heap memory, following the instruction within this document.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms