After upgrading server, Performance issue occurred in grid widget.

[HYU63]

An issue occurred in the grid after upgrading the server from 8.2.5 to 8.3.4.

The grid shows the data results with 205 properties.

It takes 5 to 10 minutes for the query results to be displayed on the grid.

It did not occur in previous versions.

As the number of properties visible through the grid widget settings decreases, the speed increases.
From this point of view, it does not take long for the stream query service to complete itself.

(Service self-completion time is also fast)

How do I get the same performance from previous versions in the new version?
Are there any issues related to the grid?

My server : redhat, postgresql9.4.3, Tomcat8.5.28, JDK1.8.0_131

(The collaboration widget also has the performance issue.)

[slangley]

Hi @HYU63.

Take a look at the Advanced grid widget available in the Marketplace as a replacement for the grid widget that you are currently using.

Regards.

--Sharon

If my response has answered your question, please mark it as the Accepted Solution, for the benefit of others who may have the same question.

[slangley]

Hi @HYU63.

Do you have an update on this issue that you can share with the Community?  Your participation in our Community is greatly appreciated!

Regards.

--Sharon

[HYU63]

Thank you for your answer.

I tried using Advanced Grid Widget it still have speed issue.

(Advanced Grid Widget is faster than Basic Grid Widget, but still slow.)

Collection Widget is also slow, After upgrading server version.

so.. I'm waiting next thingworx version.