Find Jobs
Hire Freelancers

SQL Tuning Project

$30-100 USD

In Progress
Posted over 13 years ago

$30-100 USD

Paid on delivery
We have a simple combined query that is not efficient on a MySQL server. We need someone to look at the enclosed document (using the attached sample data) and devise a more efficient query (as well give advice on keys to add and any other configuration variables on MySQL that may help performance. The resulting query could be broken up if that adds in efficiency. Deliverables include the SQL statement(s), an explanation of the keys used and when we run thru maatkit ([login to view URL]) the query-profiler should identify no issues with the query. In addition, the resulting data need to be exactly the same as the query in the attached document. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). * * *This broadcast message was sent to all bidders on Wednesday Dec 15, 2010 11:02:30 AM: To be clear - all work must be done on the programmer's computer. I will implement the SQL on our servers per your instructions. ## Platform Linux - MySQL 5.1.x
Project ID: 2985283

About the project

6 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$51 USD in 24 days
5.0 (1 review)
3.9
3.9
6 freelancers are bidding on average $52 USD for this job
User Avatar
See private message.
$85 USD in 24 days
5.0 (1 review)
0.7
0.7
User Avatar
See private message.
$68 USD in 24 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$17 USD in 24 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$63.75 USD in 24 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$25.50 USD in 24 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Platte City, United States
4.9
149
Payment method verified
Member since Jul 13, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.