Large Mysql Database causing overloading on PHP site dating site. Tweaks needed! Database GURU needed

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.


Beceriler: Veri Girişi, Veri İşleme, JSP, PHP, Web Sitesi Tasarımı

Daha fazlasını gör: mysql database overloaded, dating site database mysql, dating site database schema, dating databases, work online php programmer, the guru online, the guru com, thanks you notes, server guru, programmer notes online, programmer mysql, online php work, online php programmer, online guru, notes guru, need php programmer fast, mysql database server, my guru.com, my guru .com, my guru com

İşveren Hakkında:
( 15 değerlendirme ) Boston, United States

Proje NO: #139910



rick burns please check pmb

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(5 Değerlendirme)

Bu iş için 7 freelancer ortalamada $100 teklif veriyor


hi we can help you to get it done. rick burns

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(413 Değerlendirme)

rick burns i think that i can optimize your mysql checking the tables that more regs have and going for the solution

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)

Hi Urban Youth, Thanks for your different kinds of problem which have matched with a problem on my article site. Never mind, this problem is not so small or easy. When a database server is crash this is not for only Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

To further explain what you need done: A complete look at your database calls to join tables, index tables and to cache common data. This will increase your spped by 50-80%. Please PM me with the script your u Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I would be happy to take a look at it for you. "rick burns"

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Rick Burns... Hi, I have a lot of experience with optimizing databases, having worked on a large scale transaction processing database (typically 200000+ updates/inserts on a table a day) these last 3 years. I will ne Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)