topic Re: Speed to search information in tables? in FlexSim Forum

Speed to search information in tables?

beatriz_spaggiari — Fri, 19 Jul 2019 19:39:02 GMT

[ FlexSim 19.1.1 ]

In my model, I have many tables to be called multiple times in the simulation model. To reduce the total time the models need to run completely, I did a simple test. In the first test, I used the cell index (row numbers and column numbers) to look up the informations. In the second test, I searched the information using the names of the row headers and column headers to find all the informations I needed in the table. The difference in the amount of time between tests was huge, much more time was needed in the second test. Why does it happen? I would like to know the possible alternatives of searching information in tables that are faster to reduce the time of my simulation model.

Re: Speed to search information in tables?

joshua_s — Fri, 19 Jul 2019 22:44:14 GMT

Have you looked into SQL queries that can be done in Tables, they can increase lookup and data manipulation much faster then normal operatoions.

https://docs.flexsim.com/en/19.1/Reference/DeveloperAdvancedUser/SQLQueries/

Re: Speed to search information in tables?

joerg_vogel_HsH — Fri, 19 Jul 2019 22:49:55 GMT

Here is an answer to a similar question Table query speed. There you find different methods to accelerate your table search.