Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
I have 1000's of Streams and want to archive the old data in database using a scheduler in PostgresSQL. Can anyone please help me with a detailed steps, how to proceed to it?
Similar discussion - "Best practice to store data in Stream": https://community.ptc.com/t5/ThingWorx-Developers/Best-practice-to-store-data-in-Stream/td-p/839910
I can only provide you this link:
There is unfortunately no straight forward mechanism. When impelemnting a purge solution make sure to purge in batches so that the thingworx ScriptTimeout does not kick in and kill your service.
You could also implement something in the database directly if you want to take the risk (might break in the next twx version when e.g. the schema changes).