Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Scout » High CPU when rendering data on TablePage
High CPU when rendering data on TablePage [message #1852191] Wed, 04 May 2022 12:59 Go to next message
Luka Cavic is currently offline Luka CavicFriend
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.
Re: High CPU when rendering data on TablePage [message #1852252 is a reply to message #1852191] Fri, 06 May 2022 07:46 Go to previous messageGo to next message
Matthias Villiger is currently offline Matthias VilligerFriend
Messages: 229
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
Re: High CPU when rendering data on TablePage [message #1852295 is a reply to message #1852252] Mon, 09 May 2022 09:33 Go to previous message
Luka Cavic is currently offline Luka CavicFriend
Messages: 47
Registered: August 2014
Member
Hi, we solved it by changing garbage collector. At least for now CPU is dropping and not hanging anymore.
Previous Topic:Migration Scout22 HTML enabled Labels on GroupBox
Next Topic:How to add Country Flag to phone number field
Goto Forum:
  


Current Time: Fri Feb 23 11:37:58 GMT 2024

Powered by FUDForum. Page generated in 0.03076 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top