limiting execution time

limiting execution time

Post by Jenny Jeh » Sun, 21 Jul 2002 03:26:31



Hi there -

there are a few ways to limit query execution time

SET QUERY_GOVERNOR_COST_LIMIT value
query wait Option
dbsetltime()

these all have an upper limit rather than a range of time

is there anything which limits execution during peak or select times?

TIA!
j.

 
 
 

limiting execution time

Post by BP Margoli » Sun, 21 Jul 2002 04:15:20


Jenny,

Not to my knowledge.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:> Hi there -

> there are a few ways to limit query execution time

> SET QUERY_GOVERNOR_COST_LIMIT value
> query wait Option
> dbsetltime()

> these all have an upper limit rather than a range of time

> is there anything which limits execution during peak or select times?

> TIA!
> j.