Skip to main content
1-Visitor
November 21, 2017
Question

Duplicating a Stream with data

  • November 21, 2017
  • 1 reply
  • 1293 views

Hi everyone,

I am using Thingworx 8.0 with Postgres DB. I have a stream which receives approximately 20k records per day. Hence my query performance is very slow. Please suggest me a method to clone the existing stream to new stream without using for loop and Add Stream entry.Since for loop will slow down my server further.

1 reply

22-Sapphire I
November 21, 2017

I would offload the data to some historian over time to limit how much data is in the stream.

You can use QueryStreamEntriesWithData and PurgeStreamEntries