openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Struberg (JIRA)" <>
Subject [jira] [Created] (OPENJPA-2773) set minIdle to > 0 in DBCPDriverDataSource
Date Sat, 02 Feb 2019 16:53:00 GMT
Mark Struberg created OPENJPA-2773:

             Summary: set minIdle to > 0 in DBCPDriverDataSource
                 Key: OPENJPA-2773
             Project: OpenJPA
          Issue Type: Improvement
          Components: jdbc
    Affects Versions: 3.0.0
            Reporter: Mark Struberg
            Assignee: Mark Struberg
             Fix For: 3.0.1

Right now our {{DBCPDriverDataSource}} by default sets the {{maxIdle}} to 1. 
This is not wrong but also not really good in terms of performance.
It is usually much better to keep it at a much higher number. Usually somewhere around {{maxActive}},
except when maxActive is really high.

So I'd rather keep it at 10 or even at maxActive if this param is set.
If the connections are not used, then they will get unlocked after some time anyway.
But keeping the number 1 for {{maxIdle}} basically disables the pool, which is not wise.

This message was sent by Atlassian JIRA

View raw message