How do I know which version of ThingWorx is stable?

[Do1]

I have come across several (diverse) issues with the ThingWorx Platform which seems mainly related to the H2 version, but I have also found problems with the PostgresSQL version.

I always use Ubuntu 14.04 LTS since it is certified and the prescribed versions of Java, Tomcat and PostgresSQL.

I appreciate that there is a lot of development and we all contribute towards logging issues and squashing bugs.

However, when needing to deploy a production build, how do we know which version and combinations of Java / Tomcat / OS is MOST stable?

This becomes even more challenging if we start adding extensions and the EMS.

I would appreciate some guidance or even a rule of thumb if someone has found one that is reasonably reliable.

Thanks!

[CarlesColl]

Not for now,

We had been stick on 6.5.13 for one year and a half, and doing a lot of tests in order to move on 7.X for 6 months - starting at 7.0, we expect to move on 7.3.3 when it's released....

Neither 6.5.13 on Neo4j was super stable, Yesterday we moved on 6.5.3 PostgreSQL

Carles.

[Do1]

Thanks Charles,

Can you elaborate on OS, PSQL, Tomcat and Java versions that you are running on 6.5.3?

[CarlesColl]

Well we are on TW Cloud Services, then I don't know, I suppose the recomended ones.

On my local tests ( Development, Testing and Performance Tuning - I know Windows XP x64 it's not supported but it works and starts in a sweep ):

Performance Tests on Migration from 6.5.13 Neo4j to 7.X PostgreSQL

Hardware Configuration:

• Virtual Machine
  • Oracle VM VirtualBox
  • 3Gb RAM
  • 1CPU ( no CPU Cap )
  • Enable I/O APIC ON
  • Paravirtualization Interface: Legacy
  • Hardware Virtualization: ON Enable Nested Paging
  • No Encryption
• Host Machine
  • MacBook Pro ( 8.2 )
  • Intel Core i7-2675QM
  • CPU 2,2Ghz <-> 3,1Ghz
  • 1 CPU x 4 Cores
  • 16Gb RAM ( 1333Mhz DDR3 )
  • HD: Samsung SSD 850 EVO 500Gb over SATA
    • HFS+ with register
    • No encryption

Software Configuration:

• Virtual Machine
  • Windows XP x64 SP2
• Host Machine
  • Mac OS X El Capitan 10.11.6

Configuration 1: TW 6.5.13 + Neo4j

Operation Configuration:

• Java 1.8.0.112-b15
  • Configuration:
    • -Dd64
    • -Dfile.encoding=UTF-8
    • -Xms2g
    • -Xmx2g
    • -XX:+UseG1GC
• Tomcat 8.0.39
• Neo4j 2.1.8
• ThingWorx
  • Logging
    • ApplicationLog = WARN
    • CommunicationLog = WARN
    • ConfigurationLog = INFO
    • ScriptLog = INFO
    • SecurityLog = WARN

Configuration 1: TW 6.5.13 + PostgreSQL

Operation Configuration:

• Java 1.8.0.112-b15
  • Configuration:
    • -Dd64
    • -Dfile.encoding=UTF-8
    • -Xms2g
    • -Xmx2g
    • -XX:+UseG1GC
• Tomcat 8.0.39
• PostgreSQL 9.4.10
• Rhino Version 1.7R5
• ThingWorx
  • Logging
    • ApplicationLog = WARN
    • CommunicationLog = WARN
    • ConfigurationLog = INFO
    • ScriptLog = INFO
    • SecurityLog = WARN

Configuration 2: TW 7.2.6 + Neo4j

Operation Configuration:

• Java 1.8.0.112-b15
  • Configuration:
    • -Dd64
    • -Dfile.encoding=UTF-8
    • -Xms2g
    • -Xmx2g
    • -XX:+UseG1GC
• Tomcat 8.0.39
• Neo4j 2.1.8
• Rhino Version 1.7R5
• ThingWorx
  • Logging
    • ApplicationLog = INFO
    • CommunicationLog = WARN
    • ConfigurationLog = INFO
    • ScriptLog = INFO
    • SecurityLog = WARN

Configuration 3: TW 7.3 + PostgreSQL

Operation Configuration:

• Java 1.8.0.112-b15
  • Configuration:
    • -Dd64
    • -Dfile.encoding=UTF-8
    • -Xms2g
    • -Xmx2g
    • -XX:+UseG1GC
• Tomcat 8.0.39
• PostgreSQL 9.4.10
• Rhino Version 1.7R5
• ThingWorx
  • Logging
    • ApplicationLog = WARN
    • CommunicationLog = WARN
    • ConfigurationLog = INFO
    • ScriptLog = INFO
    • SecurityLog = WARN

[Do1]

Thank you for posting the details! Very interesting!

I notice you specify Rhino Version 1.7R5.... Why is this?  Do you install it separately? I have never seen it referenced in any of the install guides, can you please elaborate?

Thanks

[CarlesColl]

We where doing a lot of performance tests comparing Neo4j and PostgreSQL, also we have a performance test platform were we record Performance Test results, we want to know everything that can affect performance, that's the reason to record Rhino Version, then if they change it we could measure the difference.

[Do1]

That makes a lot of sense.... can you elaborate on what tools you use for performance testing?

[CarlesColl]

It's our own tool which mostly measures services execution performance, this is how it looks like

And this is the comparison between different Platform Configurations:

[Do1]

Wow!!!

Nice work!