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

[#1]

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!

[#2]

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

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