cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Scalability and performance of Thingworx

spatel-21
1-Newbie

Scalability and performance of Thingworx

Dear experts,

How would the performance of Thingworx be affected when it deals with huge amount of data and large number of transactions?

As per this blog performance of neo4j is hit once data size increases upto 50GB.

https://community.thingworx.com/community/developers/blog/2015/12/01/integrating-dse-cassandra​  so it advises to implement DSE.

When would system performance start getting a hit with DSE? How would system behave with say 250GB of data and 100M transactions per month ?

Is there any other way to support system in such cases?

Is there any test data or experimental results for such cases?

10 REPLIES 10

Siddharth, we have some metrics from our base load testing:

Http requests - Streams:

Platform CoresPlatform CPU%DSE Cores @ 4 boxesDSE CPU %# Platform Requests/sec# DSE Writes/sec
167216151780017800
16708251840018400
87982010,20010200
8804228,9008900
47942.542804280

Http requests - Value Streams:    

Platform CoresPlatform CPU%DSE Cores @ 4 boxesDSE CPU %# Platform Requests/sec# DSE Writes/sec
16351638820082000
1624855720072000
8588135,30053000
8254252,90029000
460418250025000

WS Requests - Value Streams - Single property update:    

Platform CoresPlatform CPU%DSE Cores @ 4 boxesDSE CPU %# Platform Requests/sec# DSE Writes/sec
16351651860018600
16104211790017900
1658351270012700
8258121700017000
8114311190011900
4594211100011000

WS Requests - Value Streams - Batch property update:

Platform CoresPlatform CPU%DSE Cores @ 4 boxesDSE CPU %# Platform Requests/sec# DSE Writes/sec
1635164514000140000
161086211600116000
16945810200102000
81182510,800108000
8354129,60096000
461410780078000

Hi Aanjan,

Thanks for the information. It is highly detailed and very useful.

However there are few points that I need better understanding of

1) '# Platform Requests/Sec' -- do this imply number of read requests or combination of read and write requests?

2) In the above table RAM size is not mentioned. How does RAM size affect the above data ?

3) Is there any particular reason why platform is much better able to handle WS requests rather than HTTP requests?

4) Also its clear that core size severely affects the performance. Is there any document or matrix that explains how to choose server size?



mhollenbach
5-Regular Member
(To:spatel-21)

We typically test on AWS instances with anywhere from 15 to 30 GB of memory. The most common tests seem to be on m3.2xlarge instances, and there are additional tests I'm seeing performed on the c4.2xlarge instances.

We have a Compatibility Matrix available under our support references documents:http://support.ptc.com/WCMS/files/166015/en/ThingWorx_System_Requirements_and_Compatibility_Matrix.pdf

This goes over the minimum hardware considerations when choosing a server.

Meghan

Hi Meghan,

It seems I do not have authorization to view the document. Is there any other way I can view it?

- Siddharth

Siddharth, do you have access to the eSupport Portal? The same document should be available under the 'Reference Documents' section.

I do have access to eSupport portal, but not to Refernce Documents.

Though I've upgraded the account, I'm not able to view it.

gouimette
5-Regular Member
(To:spatel-21)

Hello Siddharth,

I sent you an email directly regarding how you should be able to access our eSupport portal.  If you haven't received it, please let me know.

Best,

Gates Ouimette

gouimette@PTC.com

czheng1
1-Newbie
(To:Aanjan)

hi,Aanjan

   "Platform Requests/Sec" -- do this imply number of read requests or combination of read and write requests?The size of the write/read requests ?What is the unit?

qngo
5-Regular Member
(To:spatel-21)

spatel-21
1-Newbie
(To:qngo)

Hello,

Thanks for the reply.

I'm currently evaluating different options. I'm also exploring a hybrid model with multiple persistence providers. That can combine PostGres and DSE.

What sort of challenges might be there in such case ?

Can you share any case study or success story or any use case that you might have seen?

Top Tags