One of my client used PostgreSQL with same request before, once in a while they need to Vacuum the database to reassign some certain internal index to increase the performance. Comparatively, My SQL and DSE may be able to store more information, but on the long-run they still need to face the similar problem.
1. The way TWX store the data are the same, it create only one table for all the data coming to Stream\ Value Stream\ Datatable, My SQL and DSE might be able to store more and search faster, but there's still a upper limit.
2. How often do you need to retrieve and manipulate the data? Persistence Provider only help store the data, and data filtering is done by ThingWorx/Tomcat, performance is not much affected
For these problems, I suggest user consider [Additional Persistence Provider] and [External Database]
With [Additional Persistence Provider], new VS, Stream and Datatable can be assigned to it and expand the storage space.
With [External Database], you can keep a large amount of data, do the SQL queries in the Database side and send the result to TWX directly, save the effort of Tomcat.
