aspose file tools*
The moose likes JBoss/WildFly and the fly likes More than 1 Datasource/Connection Pool for the same Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "More than 1 Datasource/Connection Pool for the same Database" Watch "More than 1 Datasource/Connection Pool for the same Database" New topic
Author

More than 1 Datasource/Connection Pool for the same Database

Santhosh Kalisamy
Ranch Hand

Joined: Apr 15, 2008
Posts: 59
Hi,

I have been given to maintain an application.

JRE - Java 1.4.02 (I know, stone age application)
JBoss - 3.2.6 (Yes, it has been released before I born)

No of applications deployed on server : 1

and below is the datasource configuration.



For some reason, they have created 2 datasources to the same database, same schema and same user account to access. I don't know, why? and No documentation there for it.

Now, my question:

Will this affect the performance (Speed) ? If so, will it increase speed or slow down?
Siitesh Hind
Ranch Hand

Joined: Sep 06, 2012
Posts: 51
I have not seen much of a difference on the test environment that I am having.

Not deployed it on Production though to see what happens.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10213
    
166

The mere fact that there are 2 datasources pointing to the same DB doesn't necessarily have to do anything with the performance. It's ultimately how those datasources are used and what kind of traffic/user activity and other technical details of the application, that decide the performance.

[My Blog] [JavaRanch Journal]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: More than 1 Datasource/Connection Pool for the same Database