Stats Collector Table Size Strategies?

Question

question

Noah Z asked Aug 4, '20 Ben Wilson commented Aug 31, '20

Stats Collector Table Size Strategies?

I have a high throughput process flow only model where thousands of tokens are created daily and then ultimately sent to a sink a day or two later after a series of steps. I record information about each token in a stats collector that gets triggered just before the sink. All in all, for the desired model run length I would generate approximately 200k items.

I'm running into an issue where a few days into my simulation the stats collector table reaches ~75k rows and the model really slows down and can barely progress anymore. If I remove the link to write to the stats collector the model runs just fine without any slowdown. I'm wondering if there are any strategies the community might know for ways around this slowdown?

Software Version:

FlexSim 20.0.0

flexsim 20.0.0 model speed stats collector

· 2

Benjamin W2 commented · Aug 04, 2020 at 02:44 PM

@noah.zenker, can you run the performance profiler and memory profiler and take snapshots of their results? Here is the documentation:

https://docs.flexsim.com/en/20.2/Reference/Tools/PerformanceProfiler/

https://docs.flexsim.com/en/20.2/Reference/Tools/MemoryProfiler/

0 ·

Ben Wilson ♦♦ commented · Aug 31, 2020 at 05:04 PM

Hi @noah.zenker, was jordan.johnson's answer helpful? If so, please click the red "Accept" button on their answer. Or if you still have questions, add a comment and we'll continue the conversation.

0 ·

Answer 1 · 2020-08-04T16:32:08Z

Jordan Johnson answered Aug 4, '20

I'd be interested to see your actual model. I haven't seen a slowdown like that with the stats collector before, unless the rows are being sorted. In that case, it will take longer and longer to sort new rows in to the table.

@benjamin.w2 has the right idea; the performance profiler may help you discover the issue best.

question