Project Detail

MySQL Database Optimization  

MySQL Database Optimization is project number 350431
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: Zeldaze

Budget: $30-250

Created: 11/28/2008 at 22:09 EST

Bid Count: 19

Average Bid:
$ 116

12/05/2008 at 22:09 EST

Project Creator: webshoguns
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (4 reviews)

Bid On This Project
 

Description

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.

Job Type

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

becomeexpert

 

250

7 days

11-29-2008 00:17 EST

9.9947/109.9947/109.9947/109.9947/109.9947/109.9947/109.9947/109.9947/109.9947/109.9947/10
(189 reviews)

Experienced on mysql optimization. Thanks, Tonmay

help

FandaR

 

100

0 days

11-29-2008 04:29 EST

9.9846/109.9846/109.9846/109.9846/109.9846/109.9846/109.9846/109.9846/109.9846/109.9846/10
(65 reviews)

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

help

Zeldaze

 

30

0 days

11-28-2008 23:20 EST

9.9074/109.9074/109.9074/109.9074/109.9074/109.9074/109.9074/109.9074/109.9074/109.9074/10
(54 reviews)

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

help

devservice

 

30

1 day

11-29-2008 01:11 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(28 reviews)

Check PM. Thanks.

help

Technovice

 

100

3 days

11-29-2008 01:05 EST

8.4/108.4/108.4/108.4/108.4/108.4/108.4/108.4/108.4/108.4/10
(30 reviews)

Please check PM

help

SourceBurner

 

30

0 days

11-28-2008 23:09 EST

9.85/109.85/109.85/109.85/109.85/109.85/109.85/109.85/109.85/109.85/10
(20 reviews)

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

help

frankouz

 

130

3 days

11-30-2008 13:44 EST

9.9444/109.9444/109.9444/109.9444/109.9444/109.9444/109.9444/109.9444/109.9444/109.9444/10
(18 reviews)

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

help

bendriss

 

100

3 days

11-29-2008 05:39 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(16 reviews)

Hello, Please check PM.

help

phpsolutionsuk

 

200

2 days

11-29-2008 08:17 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(14 reviews)

pm for more info

help

jedrek

 

80

0 days

11-29-2008 02:27 EST

9.4167/109.4167/109.4167/109.4167/109.4167/109.4167/109.4167/109.4167/109.4167/109.4167/10
(12 reviews)

Hello, see PM ;)

help

acecoder84

 

30

1 day

11-29-2008 03:23 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(4 reviews)

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

help

RajakScripts

 

115

5 days

11-30-2008 21:13 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(4 reviews)

Hi, please check PMB.

help

fabioce

 

200

7 days

11-29-2008 02:45 EST

9.5/109.5/109.5/109.5/109.5/109.5/109.5/109.5/109.5/109.5/10
(4 reviews)

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

help

paddumi

 

175

10 days

11-29-2008 00:23 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(2 reviews)

kindly check pmb, thanks

help

AGSTechnologies1

 

250

6 days

11-29-2008 01:40 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(1 reviews)

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, VB.NET. We have worked on variety of web applications like Content Management Systems, Facebook Applications, Shopping carts, RSS Feeds, PDF generators, Banner Management, Modules Social Networking portals, Video portals, IMPORT/ EXPORT to excel, ERP's, etc. We have a very good hard working team in place who will be working on your project. Also we have good bench strength. We are looking for long term relationships and are open on price and payment terms. Please contact us right away to know more about our past work and team. We would be glad working with you.

help

bzizanovic

 

130

2 days

11-29-2008 09:09 EST

10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10
(1 reviews)

Please check PMB

help

silent1mezzo

 

30

0 days

11-28-2008 23:52 EST

(No Feedback Yet)

I've worked on optimizing different database queries before.

help

siri9

 

200

7 days

11-29-2008 02:39 EST

(No Feedback Yet)

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 dot COM"

help

LinDowsCanada

 

30

1 day

11-30-2008 18:36 EST

(No Feedback Yet)

Please ignore the bid amount and check the PM. Thanks

help


    Bid on this Project