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