I am trying to connect to the mysql server, but this takes 5 seconds.
showTime();
Class.forName("com.mysql.jdbc.Driver");
conn = (Connection) DriverManager.getConnection("jdbc:mysql://192.168.1.212:3306/db",username.getText(),password.getText());
showTime();
My problem was actually with the mysql server. I was running Windows Server 2008R2, and after I exhausted all possible answers I decided to uninstall windows and install Ubuntu Server. After that, the same exact snippet of code worked perfectly.
Braj is right about connection pooling but in case your application is not executed in a heavy container and in case is just a tiny database access, I advise you to test your connexion with a mysql client to figure out which part is slow (your application or the DBMS itself).
I suggest you to use Connection Pool where connections are already created and stored in the pool instead of creating at run-time.
In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.
Connection pools are used to enhance the
performanceof executing commands on a database.
I have already shared a nice ConnectionUtil class to manage all the connections in a single class for whole application.
Use JNDI to bind the data-source with the application rather than hard-coding username/password and configuration in the java class itself.
It's better explained under Java Tutorial on Connecting with DataSource Objects
DataSourceobjects can provide connection pooling and distributed transactions. This functionality is essential for enterprise database computing.
There is one more post on StackOverflow Why do we use a DataSource instead of a DriverManager? that explain it as well.
Move the driver class loading step in the Static Initialization Block
static{
Class.forName("com.mysql.jdbc.Driver");
}
