I'm at all costs trying to improve the loading time of my pages, but I'm suffering with a bottleneck. The connection between the web server (godaddy) and my database server (location with dedicated ip)
I ran a test with a simple page that just connects to the local database, and runs a simple command (select now ();)
This page when on the godaddy server, pointing to my fixed IP and my base, takes: Connection Time: 0.4183s Query Time: 0,1390s
However, when I put this PHP page on my local server, the times are:
Connection Time: 0,0011 Query Time: 0,0003 Using external IP as a connection and not local host or 127.0.0.1
It seems like a little time, but when I have many queries to build a page, the page takes 2, 3 seconds in total, which for google, is a very high time.
How can I reduce this godaddy time to connect to my server? Is there any network configuration from my local server?
Note: My database has 60GB, so I can not use the godaddy's MySQL server, they allow a maximum of 1GB
Thank you