I have a large global table - 660000 rows and 22 columns that I have using bundled data. Trying to update this table with new data (it is an order file) is very time consuming and some times Flexsim will hang when trying to paste in a new data set. What is the preferred method for handling data sets of this size?
Looks like when we did an overhaul to our tabling system code was changed such that it's creating an undo record for each cell that is pasted (as opposed to a single undo record for the entire paste operation). I'll add this to the dev list so we can get it fixed.
Does that mean if I delete the table and recreate it, it should work faster? I need to get a solution for how to update this table until issue is corrected by dev.
No, the issue is in the table interface. Have you tried using the Excel Import with the Data Distinction set to Values Only (very fast)? I imported 600,000 rows and 22 columns in under 20 seconds. In fact it took longer for Excel to open (about 14 seconds) than it did to do the actual import (3 or 4 seconds).
6 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
