question

Nil Ns avatar image
0 Likes"
Nil Ns asked Jason Lightfoot answered

Tables in RAM

Hello,

I’ve created a model that works by emulating the real world through importing data in real time. It works perfectly at this point.

The thing is, I need to create some statistics and tables about it. I created it using Statistics Collectors & Calculated Tables. When I executed the model for a few hours, it didn’t run at a 1 to 1 ratio with the real world, and that created fake data.. I thought that this would be a problem of Calculated Tables (they executes de SQL for all the data every time), and I just recreated that part of the model by using only tables and code, and I saved the data as Global Tables.

Now, when I run the model, it crashes after a few hours. If I open the Windows Task Manage, I see that it takes 1 Mb more of RAM every second.

Is there a method that doesn’t save that data in RAM?

What do you recommend me?

I read something about bundles, or is it better to export the data in CSV every few hours and then delete the global tables (I would prefer not to do that)


Thank you!!

FlexSim 24.0.3
ramsystem requirementscomputer configuration
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jason Lightfoot avatar image
2 Likes"
Jason Lightfoot answered

Try using bundle data as they should take less memory than global tables. Or create a database connector to a sqlite file and write to that (as FlexSim's experimenter and eventlog do).

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.