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.
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.
Linux - MySQL 5.1.x