Skip to main content
T
TanmeyTWX17-Peridot
17-Peridot
April 1, 2019
Question

Slow response even after Enough Memory allocation

  • April 1, 2019
  • 11 replies
  • 6100 views

Hi Folks,

 

I have 5000 records to display in a Mashup at a time. I have the machine configured as required.

16 GB Memory 

4 Cores Processor,etc.

But it still takes time to load that much records. I also tried increasing the size of Xmx and Xms as 12 GB in JVM variables but no luck.

 

Kindly suggest a way to speedup the loading of such size of records.

 

Thanks! 

11 replies

S
slangleyCommunity Manager
Support
April 1, 2019


Hi @TanmeyTWX.

 

There are many things to consider with slow performance.  For example, do you experience the same slow response with different browsers?  How about your environment?  Are you running the database on the same machine as ThingWorx?  Are you running other applications on the ThingWorx machine?  Which O/S are you running?

 

For starters, take a look at the following Knowledge Base articles to see if these help:


- Performance is slow when using Microsoft Internet Explorer(IE) 11 to navigate ThingWorx comparing with other browsers
https://www.ptc.com/en/support/article?n=CS227037

- How to capture and view the full HTTP Request/Response sequence for performance investigation against a ThingWorx server
https://www.ptc.com/en/support/article?n=CS224691

Regards.

 

--Sharon

T
TanmeyTWX17-PeridotAuthor
17-Peridot
April 2, 2019

Hi Sharon,

I'm using only Chrome browser(recommended one).I have Thingworx installed with Postgres SQL on same machine and there is no other application is installed on that machine. Windows is the OS being used for it.

 

Requirement: I'm querying 2000 records from DataTable at a time,to display onto grid.which takes around 8-10 seconds to display. Is there any way to reduce this loading time of records?

T
Tudor14-Alexandrite
14-Alexandrite
April 4, 2019

The .har file requested above will let us know if the performance drag is due to the server processing (e.g. slow queries?), or if it's a rendering issue in our default grid. Note that we have a Grid Advanced extension on the PTC Marketplace that has been optimized for larger datasets (and will replace the built-in grid eventually).  Thus, in parallel you may want to test the performance of the Grid-Advanced extension.

Terms & ConditionsAccessibility statement