I'm working with two DataSources from a MySQL database in the same servlet.
Each DataSource is using it's own Connection Pool, currently set at 10 connections each.
First, how do I now what is the optimal number of connections to set for each pool?
Second, would it be bad practice to re-use the same Connection object to connect to the second DataSource without closing the connection to the first? (I'm thinking I might be able to get a little better performance this way).