I use to use individual connections to connect from our JSP pages to Postgresql. Then we setup a pool in jboss in postgres-ds.xml, in my deploy directory. We use a datasource also setup in JBOSS, used in our JSP pages.
But our stress testing results show that with pooling its about 10% slower than without pooling. What can I configure to make it faster?
Here is what I have setup so far:
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<blocking-timeout-millis>50000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
I think I found my problem, the old way we use to connect didnt use a datsource, now we use a datasource to look up the pooling, Its about 0.04 seconds slower. Is this expected if one compare something that didnt use a datasource before, and now you do?