topic Re: Run a SQL query in jsl results in the update from multiple queries slowing table creation in Discussions

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

AlbertLesire1 — Fri, 25 Jul 2025 15:48:44 GMT

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

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

jthi — Fri, 25 Jul 2025 15:53:43 GMT

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).

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

bryan_boone — Mon, 04 Aug 2025 14:54:58 GMT

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.