I am attempting to make all my DB queries Named Queries, however I have some scripts that interface large datasets from some of our other enterprise data systems. These queries are slow and expected to be slow and run as gateway scripts.
Trouble is it appears that Named Queries always time out after 60 seconds. However if I look at the logs on the GW the query finished executing at some point with no error.
I don’t see a timeout option for system.db.runNamedQuery is there a way around this or do I need to use legacy DB queries?