Run a SQL query in jsl results in the update from multiple queries slowing table creation

Question

Hi I'm trying to troubleshoot why when I re-run a SQL script in JSL the result is the updates of different queries before the table is created.

See outputs in print screen

Note the JSL script is producing numerous tables for different attributes. The example shown is for 1 of the tables

JMP question.jpg

bryan_boone · Answer

If you're running New SQL Query, you'll want to run it in the foreground

Names Default To Here( 1 );
obj = New SQL Query(
	Connection( "ODBC:DSN=mydsn" ),
	Select(),
	From( Table( "my_table", Schema( "my_schema" ), Alias( "t1" ) ) )
);
table = obj << RunForegound;

You can also deselect "Run Queries in the Background" in JMP Preferences.

jthi · Answer

Could you just remove those table scripts? If you are using concatenate it can MASSIVELY slow down due to the table scripts and this could be happening somewhere with JMP created scripts (not sure though).