Performance factors in remote database access

Question

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.

have you checked the database size, is your dev db a replication of test db? — , Dec 08 '11 at 15:10
@PrasannaTalakanti: yes, the db size is same, exact replica. — , Dec 08 '11 at 15:11
network latency - Did you test ping (ICMP) with the host name from the jdbc url? — ollins, Dec 08 '11 at 15:16

score 2 · Accepted Answer · answered Dec 08 '11 at 15:18

The most likely candidates are network latency and load. Is the database server being used by any other applications? What's the latency to the database server, and how much bandwidth is available?

I'd start the investigation with some query profiling on the DB server. You could easily compare query times on the production DB to your local to determine whether or not the server itself is a factor. If not, move on to profiling the network.

Performance factors in remote database access

1 Answers1