How do we set a timeout for all the queries in the database

[BAO]

Hi,
I want to know if there is a "timeout" parameter that
we can set; to limit query execution.
thanks

[dknight]

You can set up user profiles that limit the amount of resources used, for example, CPU per session, CPU per call, etc.

[launchpad]

I think the requirement here is to throw out the user/ throw error, if the query is taking more than stipulated time. Easy one then, just assign logical call limit to a profile and assign that profile to user, in this way you are ensuring that there are no expensive queries that are runnig on the database and achiving ask of resource restriction as well!