Hi everyone,
I have a web application running on
Tomcat that accesses data from a MySQL database.
However the time taken to establish a connection is very long.
The function that I'm using to connection to the database is
It takes an average of 9 seconds to establish the connection. Query time is <1s depending on record size.
However, running the same function from Netbeans takes less than <1s from the same machine.
Hence, I would like to know if there's additional delay or firewall accessing the MySQL from Tomcat web application as compared to a direct connection.