The title says it all, is there any way to find out what is the most storage capabilities offered by Thingworx?
Thanks in advance
Solved! Go to Solution.
ThingWorx can store a LOT of data if you wanted to, especially if you are connected to InfluxDB.
The bigger challenge is to efficiently then query that data.
There are some other articles on this on this forum and support.ptc.com about that.
Brief answer to the question, after TWX 8.3, you will not use up the BigInt index number for the twx tables, but you still need to worry about the hardware limit and system potential when you store all the data in 1 persistence provider.
Real case scenario, I've a client keeping a very big valuestream table, 1.6T, when they need to upgrade after TWX 9 (when timestamps will get a little change in the table), their DB upgrade take over 5 days to complete, which is never acceptable in production environment. And when they need to query data, upgrade, migrate, DB vacuum, there will be huge costs
Still suggest them to use external DB, second persistence provider to hold stream and valueStream (influx, or another pgsql)