Table sort

[tomi_kosunen]

[ FlexSim 20.2.3 ]

Hi

I have Table that has ~88000 rows and 2 columns (both numeric). I have to sort the table by a column 1 (on model reset). The sort takes about one minute to make. Is there a way to make it any faster?

Used command: myTable.sort(1);

[lars_jacobsen_ScandiSim]

Have you tried to use Table.addIndex and Table.getRowByKey instead of sorting your table? It requires that it is a bundle table.

[MBJEBZSRG · Accepted solution]

Hi Tomi,

As Lars said, addIndex() is perfect for that task, but remember that it only works on Bundle Data tables. An alternative is to use a query with a ORDER BY Column1 ASC/DESC, Column2 ASC/DESC. This is also pretty fast even on non indexed / non bundle tables.

I did a small test with a table with 88000 rows and two columns.

• Using Table.Sort() took 158,76 seconds
• Using a query and dumping the sorted result in another table took 0,77 seconds
• Converting the table to bundled data and indexing both columns ordered and then using Table.Sort took 0.04 seconds.
• Using a query on the bundled table took 0,35 seconds.

[tomi_kosunen]

Perfect. What would be the sql syntax, if the Column header has space in its name, like

"Sort Order"?

This doesn't work: string queryStrings = "SELECT * FROM OrdetTable ORDER BY 'Sort Order' ASC";

[lars_jacobsen_ScandiSim]

You need to use square brackets [] when you have names with spaces. "SELECT * FROM OrderTable ORDER BY [Sort Order] ASC"

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

[Ben_WilsonADSK]

Hi @tomi.kosunen, was martin.j's answer helpful? If so, please click the red "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.