176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Optimizing mysql queries
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Oct 5, 2010
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Sep 23, 2010
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $500 - $1,000
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We have a web application that displays graphs and data based on information stored in a mysql database. Those are SELECT queries that can get quite complex in some cases.

The response time varies and sometimes gets to several seconds. We'd like to optimize this drastically, and cut it down to under 1 second for the query response, at least for the main queries in the system.

We are open to suggestions both in the mysql configuration and in modifying/optimizing the queries themselves, but we would like to accomplish this without upgrading the hardware (it is a Dell R200 with 4GB RAM)

The UI is written in Perl.

The project will be declared successful if all (or at least all frequent) queries take less than 1 second to complete while a single user is logged in the system.

Sign in or Register to see more

Desired Skills
MySQL Administration, SQL
Job ID: 21319080
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Greece
We are a software company which aims on Web technologies. MySQL, SQL-Server, Python, Twisted, PHP, Perl, Joomla, Drupal, zenCart are a few of the...
1
  |  
 4.7   |  $200 Earnings   |  0 Jobs
Bid ID: 21440786  |  Submitted: Oct 4, 2010 18:33 ET 
Proposal SEALED

 Ukraine  |  
10+ years in administration linux servers, networks, MySQL, perl/php/c/c++ scripting.
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21432197  |  Submitted: Oct 4, 2010 06:18 ET 
Proposal SEALED

 Romania  |  
Currently MySQL DBA at Netbridge Development, Romania. I have CMDEV (Certified MySQL Developer) and CMDBA (Certified MySQL Database Administrator)...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 21419136  |  Submitted: Oct 2, 2010 13:03 ET 
Proposal SEALED

 China  |  
10 years IT industry experience. Rich implement experience in Perl(Catalyst)/Php programming , Strong MySQL experience, system analysis and design.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21379625  |  Submitted: Sep 29, 2010 05:10 ET 
Proposal SEALED

 Czech Republic  |  
Programmer, Software architect
2
  |  
 5.0   |  $80 Earnings   |  1 Jobs
Bid ID: 21337111  |  Submitted: Sep 25, 2010 11:54 ET 
Proposal SEALED

 Russia  |  
Winner
I'm freelancer and opensource developer with math background since 2003. I use Linux platform for my everyday tasks: software development and...
2
  |  
 4.1   |  Private   |  1 Jobs
Bid ID: 21335918  |  Submitted: Sep 25, 2010 08:23 ET 
Delivery
Within 1 week
$600.00

 India  |  
We specialize in Open Source projects and between us, we have worked on projects such as a Workflow management system in the internet advertisement...
2
  |  
 5.0   |  $510 Earnings   |  1 Jobs
Bid ID: 21330172  |  Submitted: Sep 24, 2010 16:04 ET 
Proposal SEALED

 India  |  
Spry Techies is here to help you address your challenges in web programming, website development and information technology. We provide high...
8
  |  
 4.9   |  Private   |  19 Jobs
Bid ID: 21323857  |  Submitted: Sep 24, 2010 06:17 ET 
Proposal SEALED

Quintet Solutions      
One or more team members at  are verified.  Learn More
 India  |  
We are a team of professional and dedicated technophiles having our area of expertise spread over web, mobile and server consulting arena.
8
  |  
 5.0   |  Private   |  5 Jobs
Bid ID: 21321247  |  Submitted: Sep 24, 2010 01:40 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »