Way to set "Optimize Column for Lookup" with FlexScript

[axel_kohonen]

[ FlexSim 17.2.5 ]

Hi,

Is it possible to set a certain column in a Global table in bundle mode to "Optimize Column for Lookup" with FlexScript and how in that case?

And is there any more info on when it i wise to use the column indexing which it seems that the optimization does according to this thread? I assume that it adds some overhead.

And if there would be something about this in the manual it would be great! Looked in the 18.0.2 manual as well.

Thank you!

Kind regards,

Axel

[Matthew_Gillespie · Accepted solution]

data is the node holding the bundle data

startCol is 0 based

//Toggle on
applicationcommand("addindextobundlefield", data, startCol, BUNDLE_FIELD_INDEX_MAP);

//Toggle off
applicationcommand("removeindexfrombundlefield", data, startCol);

[jing_chen]

Hi @Matthew Gillespie.

It seems not working in 17.2. Does it only work in FlexSim2018?

[axel_kohonen]

Thank you @Matthew Gillespie

It works nicely! Any more info on when it makes sense to optimize columns and when not?

@jing.chen

It does work for me in FlexSim 17.2.5 so not sure what is not working for you.