<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Configuration of Datasource: min-pool-size and max-pool-size
</h3>
<span style="margin-bottom: 10px;">
reply from <a href="http://community.jboss.org/people/ruchirc">Ruchir Choudhry</a> in <i>Performance Tuning</i> - <a href="http://community.jboss.org/message/555973#555973">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><span style="color: #333333; font-family: georgia,palatino; "><em>Hello Emili,</em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em><br/></em></span></p><p><span style="color: #333333;"><span style="font-family: georgia,palatino;"><em>Max and Min connection size  can become counter productive if not </em></span><em>set properly</em><span style="font-family: georgia,palatino;"><em>, as when the server starts it reserves the connection(Handle) to the  DB in active state.Its also consumes resources as more thread is allocated to the server and hence more objects is on the stack and hence it will use more RAM/CPU. You need to also check the max connections allowed in the DB. Please check the timeout for these connections too.</em></span></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em><br/></em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em>Its a good practice to start with a lowere number, like 10 min and 60 max, see how the system behaves.</em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em><br/></em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em>You have also mentioned that you have 50 concurrent users: In response to that, the algorithm in the J2EE container dose the hashing and rehashing of the connections, some times it reuses the connections too, its also dependent on  DB connection timeout both from J2EE container and from the DB.</em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em><br/></em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em>Thus you have to check all these before coming to a right configuration.</em></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #333333; font-family: georgia,palatino; "><em>Let me know if you are not cleare with anything <br/></em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em><br/></em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em>Thank You,</em></span></p><p><span style="color: #333333; font-family: georgia,palatino; "><em>Ruchir</em></span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/555973#555973">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in Performance Tuning at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>