Connection pool
Set the size of the connection pool of the Interact runtime data source using the application server console. Take into account the number of concurrent users and the connections made during the lifetime of a session, which includes loading profile, loading offer suppression, reads and writes from flowcharts, and reads from learning.
Feature/Option
Connections Required If Enabled
At least one of the following features is enabled
*
Load profile table
*
Load Offer Suppression table
*
Load Score Override table
1 connection per concurrent client call to startSession or setAudience
It does not matter if only one table load or all three table loads are enabled.
Learning
2 connections
At least one logging or tracking service enabled
The value of Interact > services > threadManagement > flushCacheToDB > maxPoolSize. The default is 5.
Flowcharts that make at least 1 database call
The value of Interact > flowchart > maxNumberOfFlowchartThreads. The default is 25.
For example, if you have the following requirements.
*
Require that 30 concurrent calls to startSession not wait when obtaining a database connection (30)
*
Have learning turned on (2)
*
All services turned on (5)
*
Have at least one deployed flowchart that makes a db connection (25)
*
Rely on current defaults (0)
Then you should set up a database connection pool size with a minimum of 62 (30+2+5+25) for optimal performance where no single consumer of the connection will wait.
Copyright IBM Corporation 2013. All Rights Reserved.