[jboss-user] [Datasource Configuration] - Re: Database connection taking time in Jboss as 7.1.1

[Wolf-Dieter Fink]

Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion

"Re: Database connection taking time in Jboss as 7.1.1"

To view the discussion, visit: https://community.jboss.org/message/763218#763218

--------------------------------------------------------------
Hi,

the configuration looks not bad.
How do you measure? Do you use the same application and add only the getConnection()? This might avoid other bottlenecks.
Do you use a DB query or only connect?
Do you have GC logging enabled that we can sure this is not the issue?

>From the statistics it looks like that only 100 connections are used (MaxUsedCount) and there is only less wait for a connection (AverageBlockingTime / TotalBlockingTime)

You might add time statistic to your code that you are able to see where the time is spend.
Also you might set min-pool-size==max-pool-size to avoid releasing connections and start after the pool is filled up.
Maybe the bottleneck is the network or database?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/763218#763218]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20121004/13a883a2/attachment.html