PHP Mysql connection performance on remote server

0

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

    
asked by anonymous 21.07.2016 / 01:27

0 answers