Greetings all, we have a media social networking site on a dedicated server that needs a very good MySQL and Database query optimizer.
Here is our server information
* Intel CeleronD [url removed, login to view] GHz CPU
* 1 GB DDR2-800 RAM
Running on plesk control panel, Linux, and updated versions of PHP and MySQL
Here is what the project includes:
We currently have a website that is running extremely slow due to how many records it has in the database (Close to 350,000 videos, pictures etc.). The site doesn't have a large load at all, and we are experiencing slow times because of slow database queries that take up too much system resources. Its a fairly cumbersome website, but with some good tweaking and optimizing the website will be much smoother.
We have not optimized MySQL yet and fine tuned it. This needs to happen as well. Once this is done the programmer will then go through our site programming and optimize all of our DB MySQL queries to make them fast and efficient. The load time of the site needs to be dramatically changed.
If you are interested in looking at our site please let us know in private message board and we will provide you with the link.
Thanks, please only bid if you are an experienced MySQL and PHP optimizer, it needs only to be optimize by people who know what they are doing.