Our Java application has several threads that use JDBC to write to several tables. Currently, we use one JDBC connection. Would performance improve if we used a connection per table? Is a single connection bad for some reason?
Since connection pooling is a hot topic, I'm wondering if we're missing out somehow. Thanks Jeff