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.

Taidot: PHP

Näytä lisää: 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

Tietoa työnantajasta:
( 3 arvostelua ) Düsseldorf, Germany

Projektin tunnus: #206718

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Ready to the work with your budget. Thanks, Subikar

$30 USD 1 päivässä
(117 arvostelua)

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 1 päivässä
(8 arvostelua)

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 1 päivässä
(1 arvostelu)

Hi,I can do that.

$100 USD 2 päivässä
(1 arvostelu)

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

$30 USD 0 päivässä
(0 arvostelua)

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

$30 USD 0 päivässä
(0 arvostelua)

can be done.

$30 USD 0 päivässä
(0 arvostelua)