Configuring the Query Timeout setting for the Virtuoso Facet Browser
What
The Facet Browser's timeout setting is configurable by instance owner or other user with DBA privileges.
Why
Administratively controlling the maximum query timeout ordinary users may apply helps protect against accidental and intentional denial-of-service attacks, by timing out excessively long-running queries.
How
By default, the Facet Browser's query execution timeout, fct_timeout_max
, is set to 20000
milliseconds ( = 20 seconds).
A user with administrator privileges can alter the default setting with a command like this (setting it to 30000 milliseconds, or 30 seconds):
Single Server:registry_set (''fct_timeout_max'', ''30000'')
Cluster:
cl_exec ('registry_set (''fct_timeout_max'', ''30000'')');
Related
- Virtuoso Tips and Tricks Collection
- Installation and Configuration of the Virtuoso Facet Browser
- Virtuoso APIs for Faceted REST services