950818_en-US

liliconcom

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

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=""></GET>

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

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;

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

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

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

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

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

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

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

try(current data table()<

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

Thanks!

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

It seems that version 18 and later versions separated the front-end and back-end, probably because the software was refactored using a new language. Many bugs haven't been fixed yet. Try JMP19 and see if it runs smoothly.

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

Thanks! I'll try version 19.