mysql connection speed.

[ismail arslan]

hi all,

i have database a driven code which connects to a mysql server located in my local network. i noticed that each query takes to 70-100 ms to run. this performance satisfies me. but there is a problem on connection.. the act of connection, takes 4700 ms in my local network, that is too much time for me (5 seconds!).. i discovered that something wrong in connector. because when i try to connect from a location on internet, it takes 5500 ms..

this is the code which i use:

try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://"
+ targetHost + "/schema1" , "root","passtimespass");

if(debug)
System.out.println("connect1: connected!");
}
catch(Exception e){

System.out.println("_____ Error occured on connect1 in DbObj");
System.out.println("_____ Error msg: " + e.getMessage());
}


what's the problem, and i how can i solve?

thanx.