Is there any way to increase the mysql speed? Because it takes forever to connect to the database and show my files..
Is there a program I need to increase the speed to the mysql server?
EDIT: I am connecting to Frihost's MYSQL (read my other post in this forum)
No special programs (that I know of). Are you sure it's the connections and not your queries that are slow?
If your using frihost's mysql remotely, it will of course be slower. (The word 'remote' is the reason why)
So for best results (faster) just host myself? The problem is I don't got much ram... so..
Using a database at the other end of the world is usually pretty slow since for each time you need to make a connection and transfer the data. If you have several queries on one page, then that will cause a very long page load. Better use a database on the save server/computer or on a server in the same network.
Okay thanks Bondings, question though. If you host it on localhost (make the connection connect to localhost) does the "querys" even go to the internet? Or does it just query it in the mysql?
Yes, but I am running a program that attempts to get to the mysql. So does that still go to the INTERNET and then COME BACK TO THE SAME COMPUTER and query in the mysql database?
No files are viewed on apache.
They do, but I am now talking about a local mysql server. Okay to explain better:
1. The program is on one computer.
2. The mysql query is on the SAME computer
Does the program (that does querys like SELECT * FROM `table`) send the query to the internet, and then come back to the SAME computer and put the mysql query into the mysql?
Or does it just go straight to the computer?