Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction

Franck_R — Fri, 09 Jun 2023 22:00:19 GMT

Hi,

I would like to speed up some SQL queries with special configuration values for my postgresql database.

For example: SET random_page_cost = 1

How can I do this in JMP?

Indeed if I create a CustomSQL query

SET random_page_cost = 1

Then a another one with a classic SELECT FROM... it doesn't work because the value "random_page_cost" seems to be reset to its default value on the second database connection.

Is it possible to chain 2 instructions in a same CustomSQL() statement in JMP? How?

Thanks!

Re: Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction

ih — Fri, 18 Dec 2020 19:24:51 GMT

Could you combine them in a single string and run them both at once?

sql = "SET random_page_cost = 1; SELECT FROM...;"

topic Re: Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction in Discussions

Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction

Re: Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction