Skip to main content

How many database connections are created simultaneously ?

Written by Maxime

Question

How many database connections are created simultaneously when using Scriptura ?

Answer

Tracking
The default pool size is 30, but there is a configuration option in the tracking session alias that can overrule this default value: com.id.scriptura.tracking.configuration.session.impl.jdbc.pooledconnection.connections.max

Event Flow
​
Event Flow uses Tracking as DB back-end, so it uses the same settings.

User Store (Store/Retrieve/Delete pages)
​
1 connection per step, which is released when the step's flow instance has ended, however nothing is done when the flow instance ends abnormally.

Forms store
​
The default pool size is 10, but there is a configuration option that can overrule the default: /config/server/htmlforms/administrator/store/connection-pool-size

Flow Store
​
The default pool size is 10, but there is a configuration option that can overrule the default: /config/server/documentflow/database/connection-pool-size

Messages DB
​
The default pool size is 10, but there is a configuration option that can overrule the default: /config/server/messagehandler/database/connection-pool-size

Custom server applications
​
Custom steps and applications may also use connections to the database.

Did this answer your question?