I have a Java application which accesses a database. I tested it on my local machine with local database and it works just fine. But when I test it in our test environment where the application server and database server are differnt, the performence is terribly slow. The possible reasons I can think about are:
- The time to get the database connection
- Overall network traffic
- Amount of data being selected and transferred
- Load on the database server (other applications accessing the database).
- Server configuration (e.g. memory allocated, connection pool size, etc.)
Which other reasons can affect the performance?
I am using JDBC with MySQL. Any help is appreciated.