176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Need to optimize Select Statement
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.

Dec 28, 2012

Job awarded.

Dec 27, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Dec 27, 2012
  • 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: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Hello, I have a select statement, which is taking over 2 minutes to execute. I don't have too many rows, so it shouldn't take that long. Attached is the select statement, along with the execute time with and without indexing.

I need some guidance on optimizing my select statement and/or database.

I would prefer to leave the select statement as-is because I do not want to have to modify the code. I would rater tweak the MySQL DB.

The person bidding on this MUST be a MySQL expert.

*** Do not bid without reviewing the attached document ***
*** Do not big blindly and forward me your companies template ***

You need to review my project and tell me what you can do for me by helping me solve my problem.

Thanks,
Neil

Sign in or Register to see more

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

 Greece  |  
Winner
SQL expert, database and query optimizations
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36340621  |  Submitted: Dec 27, 2012 08:21 ET 
Delivery
Within 1 day
$50.01

 Russia  |  
Wordpress / Woocommerce / API expert. Bespoke complex backends / integrations.
9
  |  
 4.9   |  Private   |  73 Jobs
Bid ID: 36339578  |  Submitted: Dec 27, 2012 07:31 ET 
Proposal SEALED

 Serbia  |  
Skilled web programmer and software developer with experience in MySQL, Java, SQL Server, C# and embedded C and Assembler programming of Microchip...
9
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 36339463  |  Submitted: Dec 27, 2012 07:25 ET 
Proposal SEALED

Serhii Berezovych      
Serhii Berezovych's identity has been verified.  Learn More
 Ukraine  |  
6 years programming experience Skills: Oracle, MySQL, C++, PHP, JavaScript (jQuery AJAX)
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36339385  |  Submitted: Dec 27, 2012 07:21 ET 
Proposal SEALED

 Poland  |  
I'm a freelance developer with 7 years of experience under my belt.
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36339342  |  Submitted: Dec 27, 2012 07:19 ET 
Proposal SEALED

 Argentina  |  
Since 1982, my life has been all about computer programming. First as a hobby, and since 1992 as a profession. Microsoft Certified Solution...
3
  |  
 2.5   |  $3,133 Earnings   |  3 Jobs
Bid ID: 36339049  |  Submitted: Dec 27, 2012 07:05 ET 
Proposal SEALED

 Pakistan  |  
Experienced PHP, ASP.Net developer, expertise both in desktop and web application. Expert in database driven application with excellent user...
11
  |  
 4.9   |  Private   |  58 Jobs   |  1 verified credential(s)
Bid ID: 36338576  |  Submitted: Dec 27, 2012 06:41 ET 
Proposal SEALED

 India  |  
Winner
We are an Information Technology solutions and services provider that caters to clients all over the world. We are a total solution provider in...
1
  |  
 4.7   |  $3,970 Earnings   |  4 Jobs
Bid ID: 36337975  |  Submitted: Dec 27, 2012 06:12 ET 
Delivery
Within 1 day
$20.00

 China  |  
CHINA WEB EXPERT I have been acting as a freelancer for 8 years, so that I could own a rich experiences and skills in various aspects. I mastered...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36335155  |  Submitted: Dec 27, 2012 03:57 ET 
Proposal SEALED

 Saudi Arabia  |  
I have a wide experience of Designing and Web designing. can design eye catching website and logo according to you need. future support to clients.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36334835  |  Submitted: Dec 27, 2012 03:40 ET 
Proposal SEALED

 India  |  
Bitcoin, Litecoin or any Crypto Currency, PHP 5.4, MYSQL, Wordpress, Zend, HTML/CSS, HTML5/CSS3, Twitter Bootstrap, PSD to Wordpress, PSD to...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36334200  |  Submitted: Dec 27, 2012 03:02 ET 
Proposal SEALED

Yug TechnoSoft      
One or more team members at  are verified.  Learn More
 India  |  
Yug TechnoSoft is a software development company. We are team of Professional Developers, QA, Designers, Project Managers. Our team has a huge...
5
  |  
 4.4   |  Private   |  4 Jobs
Bid ID: 36333794  |  Submitted: Dec 27, 2012 02:39 ET 
Proposal SEALED

 Russia  |  
Python, django, data analytics, digital signal processing, transportation systems. Also have qualified iOS and Android developers in my team.
3
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 36333741  |  Submitted: Dec 27, 2012 02:36 ET 
Proposal SEALED

 India  |  
1 + year of experience in Struts, 2 + year of experience in spring and hibernate, 1+ year of experience in C#. Work with Oracle, MS-Sql, Mysql as...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36333738  |  Submitted: Dec 27, 2012 02:36 ET 
Proposal SEALED

Over 15 years experience as developer and from 8 years as web developer and database administrator. I am a specialist in Unix and Linux systems. I...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36333706  |  Submitted: Dec 27, 2012 02:35 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »