Very slow Execute SQL() using ODBC driver
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...