Very slow Execute SQL() using ODBC driver

FN — Wed, 14 May 2025 11:39:57 GMT

I am able to extract time-series data using JSL and ODBC but JMP is extremely slow.

For example, for a dataset with 50k rows and 5 columns JMP takes 50x longer using the same ODBC driver but its native tool. We breakdown the queries not to have more than 1M rows per query, so the server can handle the load with ease.

I think JMP is prefetching or treating the query as normal SQL.

In the documentation (JMP 18) I found that there are multiple options, but I am not sure how to change them using JSL.

Any ideas?


SQL_connection_str = "DRIVER={...};HOST=servername;PORT=....;MAXROWS=1000000;CHARFLOAT=N;CHARTIME=N;CHARINT=N";

dbc = Create Database Connection( SQL_connection_str );

SQL_query = "SELECT ... WHERE..";

start=tick seconds();

dt_temp = Execute SQL( dbc, SQL_query );

end=tick seconds();

runtime=end-start;
show(runtime);

Re: Very slow Execute SQL() using ODBC driver

bryan_boone — Fri, 16 May 2025 14:34:49 GMT

What Database are you using?

Re: Very slow Execute SQL() using ODBC driver

FN — Mon, 19 May 2025 20:16:51 GMT

Aspentech IP21. JMP uses its 64-bit ODBC driver to connect to it.

topic Very slow Execute SQL() using ODBC driver in Discussions

Very slow Execute SQL() using ODBC driver

Re: Very slow Execute SQL() using ODBC driver

Re: Very slow Execute SQL() using ODBC driver