Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Overview


Styleclass
ClasstopLink

top

Once you have created a data source connection, you can view or modify its advanced connection parameters. This is done by accessing the Connection page in the Administration module.

...

A connection pool is a collection of connections between Yellowfin and your database; each connection processes a single database query, so the limit set in the pool ensures how many queries will be processed simultaneously. This warrants too many queries from being processed and slowing down the system's performance.

Section


Column
width40

Image RemovedImage Added


Column


Name

Description

Min Connections 

The minimum number of connections that can be opened simultaneously.

Max Connections

The maximum number of connections to be opened simultaneously.

Refresh Time

Define how long should a connection be created for. When this limit is reached, and the connection is not processing a transaction, the connection gets deleted. A new connection will be created if required.

Timeout

At times a query can take too long to run (for example if processing large amounts of data). Use this to specify how long a single query should run before it’s cancelled.

Use secondary pool

Enable this to employ the use of a secondary pool. This pool will only be used for managing background processing, unlike the first one that’s ideal for front end processing.

If enabled, you can specify connection and timeout limits specific to this pool, as described in the above configurations.



...

horizontalrule

Styleclass
ClasstopLink

top