Table Summary in JMP14 takes very long time compared to JMP12.
Oct 5, 2019 12:42 AM(753 views)
I have a table with 2 columns, DATETIME and MESSAGE. Message column is ~60 characters.
The table has ~3 million rows, with many duplicate rows because this is a concatenation of many files with some of the same data. I am attempting to get rid of the duplicate rows as fast as possible, which worked fine in JMP 12.2.0.
In JMP 12.2.0 the Summary takes ~8 seconds. In JMP 14.3.0 the Summary takes an unknown amount of time because I killed the process > 30 minutes.
dt2 = dt << Summary( Group( :DATETIME, :MESSAGE ), Invisible, Link to original Data Table( 0 ), Table Name( "MessageTable" ) );