In Progress

Optimise MySQL Query

[I'm re-posting this project with slightly modified requirements]

I need someone to optimize a PHP/MySQL query which is slowing down my board software. It should get rid of "SELECT DISTINCT", just like described at [url removed, login to view]

What is most important, that no longer a mysql tmp table is being created for the query, I think that this is the break for it.

For the specific query, see the attachment.

If I'm satisfied with the successful bidders job, there night be a lot more MySQL optimisation jobs to come.

Budget is limited to $15 as this is a rather quick job for a experienced programmer.

Skills: PHP

See more: optimise query php, software programmer jobs, programmer mysql, programmer html job requirements, programmer en php mysql, optimization jobs, n query, night jobs, mysql query optimization software, jobs for html programmer, jobs at night, html programmer jobs, html 5 dev, get job as a php programmer, break com, optimise mysql, programmer en c, it programmer jobs, dev mysql com, query table, Query optimization, programmer en php, optimize mysql, optimisation of php, mysql query

About the Employer:
( 3 reviews ) Düsseldorf, Germany

Project ID: #206718

7 freelancers are bidding on average $50 for this job

itcslive

Ready to the work with your budget. Thanks, Subikar

$30 USD in 1 day
(117 Reviews)
7.5
theisoft

hello, i have worked with databases for 10 years already and handle thousands of record and make queries to generate reports. if interested, please pm me. thanks

$80 USD in 1 day
(8 Reviews)
4.9
fabioce

I can help you. I work with MySql from many years in db designer and db optimization rules. See my link to know me

$50 USD in 1 day
(1 Review)
2.8
ask4me

Hi,I can do that.

$100 USD in 2 days
(1 Review)
1.2
Gaurav12345

I am DBA in my current project in my organization .I can do this work

$30 USD in 0 days
(0 Reviews)
0.0
dreamskiy

Hi, floid. Is faster will if use INNER JOIN instead of LEFT JOIN

$30 USD in 0 days
(0 Reviews)
0.0
mithun1200

can be done.

$30 USD in 0 days
(0 Reviews)
0.0