I have a dyanmic dating site ([url removed, login to view]) with over 80,000+ thousands members. These members have friends on the site and over 1,000,000 notes have been sent. The website MYSQL database is now crashing the server (Woodcrest with 4GB of Ram).
I need a database guru to tighten up my database calls and fix the database so it no longer causes a load on the server. Please only if you have ALOT of experience with databases, mysql and php. You will work with my on staff programmer.
1) Make site run/load fast with many users online.
2) Stop site from overloading the server.
Please NO generic bids. Include a message of why you'd be able to fix our problem such a caching etc. Hardware is NOT the issue as this site should not take 4GB of Ram to run. I'll give a bonus payout as well for this project. Be sure to include "rick burns" in your bid so I know its not generic.