Skip to main content
13-Aquamarine
July 6, 2015
Solved

Loading / Deleting Millions of Stream Entries

  • July 6, 2015
  • 1 reply
  • 1477 views

Hello all,

I am trying to import a large number of historical sensor data.

I am using a self written service to import stream entries from csv files.

The largest csv file has 2,6 million rows. During the import, the service takes some minutes and the execution was successful.

But counting the stream entries returns just 2,1 million entries.

I got the same issue by deleting stream entries. Using the "PurgeStreamEntries" serivce on the stream to delete all 2,1 million entries returns a successful result but it just deleting 1/5 of all stream entries.

Could it be a tomcat memory issue?

I am running my test system with max 8GB memory for tomcat.

Best answer by SebB

I found the solution for this issue.

I increased the "Max Queue Size" and the "Max Wait Time Before Flushing Stream Buffer" in the StreamProcessingSubsystem configuration.

1 reply

SebB13-AquamarineAuthorAnswer
13-Aquamarine
July 8, 2015

I found the solution for this issue.

I increased the "Max Queue Size" and the "Max Wait Time Before Flushing Stream Buffer" in the StreamProcessingSubsystem configuration.