Administrator

Server Configuration: Database

Configure properties to improve database performance.

Cache properties improve performance by reducing the number of times the database needs to read an object. Database pool properties improve performance by reusing established database connections. Restart the server after making any changes to database properties.

Table 36: Cache Settings
Property Description Default
Number of Registrations to Cache Number of device registrations that can be cached on the server 5000
APNS Cache Size Number of APNS configurations that can be cached on the server 5000
BB Push Service Cache Size Number of BlackBerry push service configurations that can be cached on the server 5000
Notification Target Cache Size Number of notification targets (devices) that can be cached on the server 5000
GCM Cache Size Number of GCM configurations that can be cached on the server 5000
WNS Cache Size Number of WNS configurations that can be cached on the server 5000
Number of Applications to Cache Number of applications that can be cached on the server 50
Number of Back-End Connections to Cache Number of back-end connections (endpoints) that can be cached on the server 50
Application to Back-End Connection Cache Size Number of application to back-end connection mappings that can be cached on the server 300
Table 37: Connection Pool Settings
Property Description Default
Maximum Active Size Maximum number of concurrent connections that can be made to the database 8
Maximum Wait Time Number of milliseconds a connection request waits for a successful connection to the connector pool 30000
Minimum Evictable Idle Time Number of milliseconds a connection in the pool can be idle before it is removed 90000
Minimum Idle Connection Count Minimum number of idle connections to keep in the pool 1