Speed to search information in tables?

[beatriz_spaggiari]

[ 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.

[joshua_s]

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/

[joerg_vogel_HsH · Accepted solution]

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