Eclipse Community Forums: Eclipse Scout » High CPU when rendering data on TablePage

Help

Home

Home » Eclipse Projects » Eclipse Scout » High CPU when rendering data on TablePage

Show: Today's Messages :: Show Polls :: Message Navigator

High CPU when rendering data on TablePage [message #1852191]

Wed, 04 May 2022 12:59

Luka Cavic

Messages: 47
Registered: August 2014

Member

Hi,

we are having problems when showing data to table page with more than 30 columns.

We are using Tomcat 8, OpenJDK 11, JAVA_OPTS and CATALINA_OPTS params are shown in attachment.

Tomcat is running on Ubuntu 18 VPS with 8 virtual cores and 64GB of RAM
We are using MSSQL server with JDBC driver v.7.2.1.jre8

Problem:
If 3 users at same time select press Search button to show data, CPU is very high and hanging at 95%, not dropping. Application becomes very slow and we need to restart Tomcat.

While data is loading, Please Wait dialog is show and when clicking on Cancel button, Cancel button disappears but dialog is still shown. We need to close browser and open it again.

String query = "SELECT somecolumnfromdb FROM somedb INTO :column" syntax.
We are using:
SQL.selectInto(query, pageData, filter, new NVPair("holder", holder)).

Also we tried using map data using BeanArrayHolder<MyTableRowData> and pageData.setRows(holder.getBeans());

If mapping data to BeanArrayHolder only and not returning pageData with rows, query is executed fast and no problem with CPU.

Also we removed all execDecorateCell, execDecorateRow calls, ChartTableControl components and the problem exists.

Do you know maybe cause of this problem with CPU?

Thank you.

Attachment: Screenshot_15.png
(Size: 4.22KB, Downloaded 91 times)

Report message to a moderator

Re: High CPU when rendering data on TablePage [message #1852252 is a reply to message #1852191]

Fri, 06 May 2022 07:46

Matthias Villiger

Messages: 232
Registered: September 2011

Senior Member

Hi Luka

Which Scout Version are you using?

Are you using the undeploy/deploy feature of Tomcat with your webapp?
We had similar issues with Tomcat in the past (e.g. we reported Bug 64765) which also leads to performance degradation.

Maybe you can try with the latest Tomcat 9? Does the issue remain? Can you reproduce the error locally using the Dev-Jetty server?

In the moment when the CPU is very high: Can you take a stacktrace from the Java process affected (e.g. using jstack) to check which threads are working?

Kind regards
Mat

Report message to a moderator