Connor: Created page with "Set a timeout.

schema:gisq

Users may accidentally (or deliberately) start queries which would take a very long time to complete...."

2012-07-17T13:33:12Z

Created page with "Set a timeout. <div class='ht'> <div class=params>schema:gisq</div> <div> Users may accidentally (or deliberately) start queries which would take a very long time to complete...."

New page

Set a timeout.
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
Users may accidentally (or deliberately) start queries which would take a very long time to complete.
We can set a 'timeout'; this means that the system gives up after a certain amount of time.
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-sqlite'></source>
<source lang='sql' class='def e-db2'></source>
<source lang='sql' class='def e-ingres'></source>
<source lang='sql' class='def e-access'></source>
<source lang='sql' class='def e-postgres'>SET STATEMENT_TIMEOUT TO 60000</source>
<source lang='sql' class='def e-oracle'>ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
CREATE PROFILE gisqprofile
LIMIT CONNECT_TIME 1
;
ALTER USER scott PROFILE gisqprofile;
</source>
<source lang='sql' class='def e-sqlserver'>sp_configure 'show advanced options', 1;
reconfigure;
sp_configure 'query governor cost limit', 60;
reconfigure;
sp_configure 'show advanced options', 0
reconfigure
</source>
<source lang='sql' class='def e-mysql'></source>
<source lang='sql' class='def e-mimer'></source>
<source lang='sql' class='def e-sybase'></source>

<div class="ecomm e-postgres" style="display: none">In SQL you can set the session-wide timeout
SET STATEMENT_TIMEOUT TO 60000
You can specify a limit from the system in postgresql.conf</div>
<div class="ecomm e-oracle" style="display: none">The user scott is limited to 1 minute per connection. After this time he will be logged out, if he is running a query it will be abandoned.</div>
<div class="ecomm e-sqlserver" style="display: none">The system estimates the time to complete the query before executing it. If this estimate is more than 60 then the query will not be attempted. This applies to all queries. Individual queries may override this value using the SET QUERY_GOVERNOR_COST_LIMIT command.</div>
</div>
{{Users ref}}

Set a timeout. - Revision history

Connor: Created page with "Set a timeout. schema:gisq Users may accidentally (or deliberately) start queries which would take a very long time to complete...."

Connor: Created page with "Set a timeout.

schema:gisq

Users may accidentally (or deliberately) start queries which would take a very long time to complete...."