MySQL Database Optimization

In Progress

My social networking site (php coded), which has only 2 thousand members, is very slow for following:

(i) Slow Login: Members take half a minute to get logged in. I thought I last learned that there are lots of queries run, when members are trying to log in, but yet developer did not think if anyone can be discarded.

(iii) Slow Navigation: Clicking on Search result, or visiting the profile page of any user takes very long for the page to change. This also takes half a minute.

(ii) Slow Contact buttons: Clicking on communication buttons like Flirt, Email, takes half a minute.

Can anyone be confident of optimizing mySQL database queries to speed up the processing of each of these items above to take a few seconds at most (And: No Bugs please) ?

If it takes half a minute for (i), (ii) and (iii) to happen, then if it eventually gets to, say, 10,000 members , page effectively is FROZEN, right? What about when even larger memberbase?

If bidders have previous experience on this, it will be viewed VERY FAVOURABLY, but I appreciate proof in the form of past work reviews that I can look at.

Skills: PHP

See more: joomla database optimization, mysql database optimization, php form search mysql database, mysql search optimization, optimization joomla mysql, mysql optimizing joomla, database optimisation joomla, speeding mysql database optimize, what happen, speed optimization, profile database, php mysql database, page speed optimization, mysql database , frozen, flirt, database queries, database optimization, database developer, viewed profile, queries database, email database work, mysql optimizing , mysql user, work database

About the Employer:
( 154 reviews ) SINGAPORE, Singapore

Project ID: #350431

Awarded to:

Zeldaze

I have a few ideas which I'm pretty sure will work. As a web developer, database optimization is a MUST.

$30 USD in 0 days
(104 Reviews)
6.4

18 freelancers are bidding on average $113 for this job

becomeexpert

Experienced on mysql optimization. Thanks, Tonmay

$250 USD in 7 days
(129 Reviews)
7.6
phpsolutionsuk

pm for more info

$200 USD in 2 days
(51 Reviews)
6.7
FandaR

Hi, i have over 8 years experience as Linux admin. I can optimize your mysql. Thank You

$100 USD in 0 days
(218 Reviews)
6.4
devservice

Check PM. Thanks.

$30 USD in 1 day
(95 Reviews)
5.7
acecoder84

Hello, I can do this project. Please refer PMB. Regards, Sadhan.

$30 USD in 1 day
(32 Reviews)
5.4
SourceBurner

Let's see what's the problem... Please take a look at PMB. Regards

$30 USD in 0 days
(60 Reviews)
5.3
frankouz

Hi, I have worked with some databases as mysql, sqlserver, oracle. so I am able to do the work. View PM for details.

$130 USD in 3 days
(9 Reviews)
4.8
Technovice

Please check PM

$100 USD in 3 days
(31 Reviews)
4.6
bendriss

Hello, Please check PM.

$100 USD in 3 days
(14 Reviews)
4.3
jedrek

Hello, see PM ;)

$80 USD in 0 days
(10 Reviews)
4.2
AGSTechnologies1

We have gone through the information that you have provided and understand your requirements very well. We have excellent expertise in PHP5, MYSQL, DRUPAL, JOOMLA, HTML, CSS, AJAX, JAVA, J2ME, JSP, SEO, SEM, ASP.NET, V More

$250 USD in 6 days
(2 Reviews)
3.8
RajakScripts

Hi, please check PMB.

$115 USD in 5 days
(4 Reviews)
3.4
fabioce

I have a lot of experience in MySQL architecture, design, optimization and scalability

$200 USD in 7 days
(1 Review)
2.8
bzizanovic

Please check PMB

$130 USD in 2 days
(1 Review)
2.1
paddumi

kindly check pmb, thanks

$175 USD in 10 days
(1 Review)
1.1
LinDowsCanada

Please ignore the bid amount and check the PM. Thanks

$30 USD in 1 day
(0 Reviews)
0.0
siri9

Experts on Web related development with having experiance in Latest technologies of web 2.0, having hands full of experience in Linux and Network related projects from past 4years. "More info please logon to "fugenx d More

$200 USD in 7 days
(0 Reviews)
0.0
silent1mezzo

I've worked on optimizing different database queries before.

$30 USD in 0 days
(0 Reviews)
0.0