question

CSN avatar image
0 Likes"
CSN asked Andrew O commented

find slot made model run slowly

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.

1659066276398.png

1659066290104.jpeg

1659066297002.png

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.

FlexSim 22.1.3
find slot
1659066276398.png (142.3 KiB)
1659066290104.jpeg (99.4 KiB)
1659066297002.png (72.4 KiB)
· 6
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Felix Möhlmann avatar image Felix Möhlmann commented ·

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.

1 Like 1 ·
CSN avatar image CSN Felix Möhlmann commented ·

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

So we cannot use the getSlot method.


0 Likes 0 ·
CSN avatar image CSN Felix Möhlmann commented ·

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.

0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann CSN commented ·
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.
0 Likes 0 ·
Show more comments
Andrew O avatar image Andrew O commented ·

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.

0 Likes 0 ·

0 Answers