0
I am at all costs trying to improve the loading time of my pages, however I am suffering with a bottleneck. The connection between the web server(godaddy) and my database server(local with dedicated ip)
I ran a test with a simple page that only connects to the local database, and runs a simple command (select now();)
That page when it is on the godaddy server, pointing to my fixed IP and my base, it takes: Connection Time:0,4183s Query Time:0,1390s
However, when I put this PHP page on my local server, times are:
Connection Time:0.0011 Query Time:0,0003 Using external IP as connection and not host local or 127.0.0.1
It seems a short time, but when I have many queries to put up 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 some network configuration of my local server?
Obs.: My database is 60GB, so I can’t use godaddy’s Mysql server, they allow at most 1GB
Thank you
Related: Time difference in execution of the same query between PHP and PHPMYADMIN
– user28595
Assuming your server is well configured, it is a matter of putting a better internet link on it. If it’s homemade ADSL-type link, etc., it won’t be able to compete with a dedicated link (whether it’s fixed IP or not, the link has to be good).
– Bacco
The internet link of the bank server is 50MB fixed (sending and receiving), is not enough? Would not be some other setting? Like firewall or some restriction of configuration? This server is WINDOWS and I use WAMP, but only use the base, I do not use apache
– Rodrigo Mendes
If the 50 work well even, it may be problem in the configuration of the server. Firewall may interfere, but only if you have some very absurd and complex rule.
– Bacco