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 to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Duplicating a Stream with data

kr1
8-Gravel
8-Gravel
‎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
Announcements


Contact Community Management
Top Tags