find slot made model run slowly

[supportPHJ4A]

[ FlexSim 22.1.3 ]

Hi,

I and other users met the same problem about storage sysytem.

When we use 'find slot' activity ,the model runed very slowly.

However the CPU and GPU of computer was used less.

We used 'pull from list' acitivity to replace 'find slot', and the model runed well.

So we wonder why, can this be fixed?

Otherwise the 'find slot' acitivity will be less used.

[moehlmann_fe]

What query are you using in 'Find Slot?'

If you are using the address scheme to find a specific slot it is significantly faster to use 'Storage.system.getSlot()' to look up the slot based on an address string.

If you are using slot labels, indexing them should also speed up the query considerably.

[supportPHJ4A]

There are four conditions in the query, and the address is not sure.

So we cannot use the getSlot method.

[supportPHJ4A]

At the same time, during the test, we found that using WHERE judgment will not affect the speed, but using ORDER sorting will cause the speed to slow down and freeze. Is there a good solution or improvement? Thanks.

[moehlmann_fe]

Other than the obvious way of trying to reduce the number of values that have to be sorted, I don't know if/how that could be sped up.

[jason_lightfootVL7B4]

You could try using lists with partitioning to see if that's any quicker - the partitioning might speed up the sort if you have many entries.

You could also try using maps.

[andrew_o2]

Hi @CSN,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.