It's unexpected that the file merging speed of JMP Pro 14 is so much faster than that of JMP Pro 18

[#1]

The speed of file splicing has slowed down since JMP Pro 18
I had to use JMP Pro14 again to operate.

dir="C:\0\";;Fs=Files In Directory(dir);
for(j=1,j<=N Items(fs),j++,
d1=Open(dir||fs[j],Add to Recent Files(0));na=d1<<Get Name();
if(j==1,d2=d1;d2<<setName("名2");,current data table(d2);d2<<Concatenate(Data Table(d1),Append to first table);Close(d1,nosave));
);
try(d2<<Delete Table Property("Source"));d2<<Save("D:\0\JMP\big.jmp");

[#2]

Hello Lala,

Have you tried putting Begin Data Update and End Data Update around the outside of your for loop? This example below is from the Scripting Index.

Brian Corcoran

JMP Development

dt << Begin Data Update;
dt << Add Rows( 2000 );
dt << End Data Update;

[#3]

Thanks!
Hehe, I tried it — there's almost no difference compared to my original script in JMP Pro 18.
I did a quick test merging 200 files: the runtime consistently fell between 8.7 and 9 seconds across multiple runs.
However, the exact same code completes the task in only ~1.5 seconds on JMP Pro 14

[#4]

Do your tables have table variables/table scripts? Table variables can cause massive issues if they get added as new columns.

[#5]

None of my original files have Table Property("Source").

My habit is to set Subset();And dt<<Update();All the generated sources have been deleted

try(current data table()<<Delete Table Property("Source"));

This is purely a version issue and has nothing to do with the JSL code.

Thanks!