Connection pool

Set the size of the connection pool of the Unica 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.