Em Andamento

SQL Tuning Project

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 ([url removed, login to view]) 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

Habilidades: Administração de Bancos de Dados

Ver mais: sql tuning project, sql database programmer, sample project agreement, project agreement sample, project agreement document, programmer sql, hire project help, hire a c computer programmer, sql server programmer, TUNING, Sql Database administration, performance tuning, hire sql, hire sql programmer, hire computer programmer, database tuning, computer programmer for hire, broadcast project, devise, sql statement help, SQL Server administration, platform administration, query performance, mysql broken database, mysql combined

Acerca do Empregador:
( 149 comentários ) Platte City, United States

ID do Projeto: #2985283

Premiar a:

ssusavw

See private message.

$51 USD em 24 dias
(1 Comentário)
3.9

6 freelancers estão ofertando em média $52 para este trabalho

j3pro

See private message.

$85 USD in 24 dias
(1 Comentário)
0.7
deepnayana

See private message.

$68 USD in 24 dias
(0 Comentários)
0.0
imranfree

See private message.

$17 USD in 24 dias
(0 Comentários)
0.0
roger07vw

See private message.

$63.75 USD in 24 dias
(0 Comentários)
0.0
chaithvw

See private message.

$25.5 USD in 24 dias
(0 Comentários)
0.0