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.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03570 seconds