Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

More than 1 Datasource/Connection Pool for the same Database

 
Santhosh Kalisamy
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic