Data Source Limits

The data source limits page allows admins to control core query settings for the various data stacks that have been configured on the system. Most of the settings can be set for all queries to all data source types or per data stack technology.

Settings

New Connection Timeout

This global setting determines how long Pyramid will wait to create a connection to any data source.

Pool Size

This setting determines the number of live connections that can be opened concurrently against the data source. This can be set globally or per data stack.

Query Timeout

This setting determines the time Pyramid will wait for a query response before canceling the query and returning an error. This can be set globally or per data stack.

Fetch Size

This setting determines the size of the data batches that the data stack will send. This can be set globally or per data stack.

Unused Connections Time Limit

This setting determines how long, in seconds, unused connections typically remain alive for the data source before being recycled. This is a "keep alive."