cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Duplicating a Stream with data

kr1
3-Visitor
3-Visitor
‎Nov 21, 2017 12:46 PM
‎Nov 21, 2017 12:46 PM

Duplicating a Stream with data

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.

Labels:
0 Kudos
Notify Moderator
1 REPLY 1
PaiChung
22-Sapphire I
22-Sapphire I
(To:kr1)
‎Nov 21, 2017 02:34 PM
‎Nov 21, 2017 02:34 PM

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

Notify Moderator
Top Tags