Performance Enhancement

Post Reply
sandeepkhanna
Posts: 6
Joined: 30 Jan 2015, 15:54

I was wondering if anyone on this forum has suggestions for boosting the performance of Essential Platform, and can offer any guidance to the problems we are facing.
Background:
We have upgraded to Essential 5x platform, and have repository on Linux server in PostgreSQL database on the same host.

Issue:
We have noticed that once we have high number of entries in the repository:
- Loading the project in Protege takes close to 90+ seconds
- The Import utility hangs after every 50 rows of data import, with a message in tomcat log that reads as follows:

SEVERE: >>org.zkoss.zk.ui.DesktopUnavailableException: Stopped
>> at org.zkoss.zkmax.ui.comet.CometServerPush.activate(CometServerPush.java:294)
>> at org.zkoss.zk.ui.impl.DesktopImpl.activateServerPush(DesktopImpl.java:1395)
>> at org.zkoss.zk.ui.Executions.activate(Executions.java:971)
>> at org.zkoss.zk.ui.Executions.activate(Executions.java:947)
>> at org.zkoss.zk.ui.event.impl.AsyncListenerThread.run(DesktopEventQueue.java:190)
User avatar
neil.walsh
Posts: 444
Joined: 16 Feb 2009, 13:45
Contact:

Hi Sandeep,
- Loading the project in Protege takes close to 90+ seconds
This is much longer than we'd expect. We'd typically expect even a large repository to only take between 10-30 seconds. Postgres usually performs very well with Protege and Essential.

Have you enabled (or previously enabled) the collaboration tools? Are you seeing any errors during project load (e.g. missing files)? How many instances are in the repository? You can see this information in the console during load.

The error "SEVERE: >>org.zkoss.zk.ui.DesktopUnavailableException: Stopped" occurs when the browser has timed-out. This may be a result of the import failing somehow.

The first thing to check is memory setting for the Tomcat running the import utility. We strongly suggest running this in a separate Tomcat instance to the Viewer. We also recommend a minimum of 1.5GB of memory ideally 2GB+ for the Tomcat supporting the import utility. You can refer to the Tomcat documentation on how to configure this depending on your version and OS platform.

Secondly, you can try increasing the timeout on the Import Utility in case this is timing out.

Browse to the Import Utility webapp

Open the file WEB-INF > zk.xml

Set the session details to

<session-config>
<session-timeout>1800</session-timeout>
<timer-keep-alive>true</timer-keep-alive>
</session-config>

Again finally, check the Tomcat logs to see if there are any errors being reported beyond the one detailed above.

Thanks

Neil
Post Reply