+1
We use a PostgreSQL connection to access our GreenPlum environment to execute a SQL statement to pull non-spatial point data. Normal Query runtime, runs fine.
When the tables involved in the SQL are under heavy load, the query slows down a lot. It then NEVER returns anything and will continue to run until we stop it.
So, my question is. When we setup connections in FME desktop, is there any way to setup a MAX connection timeout or Query timeout?
+13
Hi @jbradfor, if you're able to use an SQLCreator or SQLExecutor, you might be able to set the timeout there
set statement_timeout to 100;Hi @jbradfor, if you're able to use an SQLCreator or SQLExecutor, you might be able to set the timeout there
set statement_timeout to 100;
FME_SQL_DELIMITER ;
set statement_timeout to 1800000; --30 min
select distinct...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.