When retrieving data from the database in the query template I've encountered SQL timeout problems.
When I use a query that starts returning data within 30 seconds the query will continue returning data even if that means it needs to continue for over several minutes.
But if use a query that takes more than 30 seconds to start returning data it will enter a SQL timeout.
unfortunately because of the complexity of the query I am not able to change it, but is there a way to increase of even disable the 30 second timeout?
I've looked around in several config files, IIS properties, but so far I've not been able to find a solution,
Any help would be appreciated.