Project

General

Profile

Actions

Feature #3035

closed

Optimisation de la datasource

Added by David Lesimple almost 10 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Normal
Start date:
03/14/2012
Due date:
% Done:

100%

Estimated time:
Spent time:
Livraison en TEST:
Livraison en PROD:

Description

Dans silverpeas-ds.xml un paramètre est incorrect en jboss6: max-idle-timeout
Il serait souhaitable d'ajouter les options suivantes:

idle-timeout-minutes : This element specifies the maximum time in minutes a connection may be idle before being closed. The actual maximum time depends also on the IdleRemover scan time, which is 1/2 the smallest idle-timeout-minutes of any pool.
Valeur: 15

track-statements : This boolean element specifies whether to check for unclosed statements when a connection is returned to the pool. If true, a warning message is issued for each unclosed statement. If the log4j category org.jboss.resource.adapter.jdbc.WrappedConnection has trace level enabled, a stack trace of the connection close call is logged as well. This is a debug feature that can be turned off in production.
Valeur : true

prepared-statement-cache-size : This element specifies the number of prepared statements per connection in an LRU cache, which is keyed by the SQL query. Setting this to zero disables the cache.
Exemple: 15

Actions

Also available in: Atom PDF