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:
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?