UI Performance Issue

Our application UI is kind of slow. I did check the SQL logs, all the queries are performing with 2 or 3 ms. [eclipselink.sql - <t 742497489, conn 139550725> [4 ms] spent]

But when I check perfstat-ui.log, I see .edit#load takes average of 9713 ms.

Am I missing something? Can someone help me?

Performance Statistics 2020-05-14 16:08:00 - 2020-05-14 16:10:00
Tag Avg(ms) Min Max Std Dev Count
x_Offers.edit#afterShow 0.0 0 0 0.0 1
x_Offers.edit#beforeShow 632.0 632 632 0.0 1
x_Offers.edit#create 165.0 165 165 0.0 1
x_Offers.edit#init 2.0 2 2 0.0 1
x_Offers.edit#inject 1.0 1 1 0.0 1
x_Offers.edit#load 9713.0 9713 9713 0.0 1
x_Offers.edit#uiPermissions 0.0 0 0 0.0 1
x_Offers.edit#xml 4.0 4 4 0.0 1

1 Like

Hi @venkatesh,

Although individually each query is fast, probably there is a lot of them running when you open the screen.

Take a look at this answer in another topic very similar to yours.

Other things that may help:

  • Create a specific view for your screen, removing all relationships and attributes not used in the screen
  • Review your views’ fetch: use JOIN to force loading in the same select
    image
  • Review the InstanceName of entities used in the screen
  • Inpect the generic filter: by default, if you have a dropdown to select an entity, cuba will load all the instances in memory when the screen opens

Regards,
Peterson.

1 Like