How to increase executionTimeout for a long-running query?

asp.net, c#

Solution

Execution Timeout is 90 seconds for `.NET` Framework 1.0 and 1.1, 110 seconds otherwise.

If you need to change defult settings you need to do it in your `web.config` under `<httpRuntime>`

<httpRuntime executionTimeout = "number(in seconds)"/>

But Remember:

This time-out applies only if the debug attribute in the compilation element is False.

Have look at in detail about compilation Element

Have look at this document about httpRuntime Element

Problem

In my application, one query takes 3 minutes to execute. I found that Default ExecutionTimeout value is 110 sec.I tried to change this to 500 (seconds) but it didn't fix my problem. Somewhere I found that setting `<compilation debug="false">` allows the ExecutionTimeout property to be configured. However, even this didn't solve my problem. Does anyone know how I can increase the execution timeout for a long-running query?

Original source