MySQL PHP Single Query Optimisation

Dibatalkan Disiarkan Mar 15, 2012 Dibayar semasa penghantaran
Dibatalkan Dibayar semasa penghantaran

I have a MySQL query which gathers information from a range of different tables.

I have a separate DB and web server, but this particular query takes a long while to process, because it involves querying a lot of data and matching it all up.

I have attached the particular query and can send a detailed explanation of what the query actually produces and can send the tables it relates to on request from you.

What I need is a coder:

1. Who has experience in optimising such queries before and implementing solutions to speed them up

2. Who can suggest to me the best way to go about optimising this query

I have had different suggestions from different coders talking about "sliding windows" and "temp tables" but what I need is a clear and precise explanation of what you will do.

You do not need to tell me exactly how you will do it until I accept your bid, but I cannot accept a bid without a clear pathway.

MySQL PHP Memasang Skrip

ID Projek: #1505183

Tentang projek

12 cadangan Projek jarak jauh Aktif Mar 15, 2012

12 pekerja bebas membida secara purata $139 untuk pekerjaan ini

canlan318

Dear sir. I sent you a private message. Please check it. Regards.

$100 USD dalam sehari
(70 Ulasan)
6.8
triamazikamno

Professional optimizer.

$200 USD dalam 3 hari
(51 Ulasan)
6.3
svipl7

7 years old Web-Development company. please check our site. please see our portfolio for our work. thanks

$175 USD dalam 5 hari
(14 Ulasan)
5.0
silviani

Hello sir. Please check you PM

$120 USD dalam 2 hari
(16 Ulasan)
4.8
lukasa1993

The Best i Can suggest is that i will rewrite this query if you tell me exactly what it does and i will write the most optimized one

$250 USD dalam 4 hari
(2 Ulasan)
3.8
riteshagarwal90

hello sir i can solve your query and is well eqipped with php and mysql and furthermore my initial value is prettymuch less

$30 USD dalam sehari
(0 Ulasan)
0.0
dkcwebmaster

Hi, we can do this..Looking forward to discuss more on this

$150 USD dalam 2 hari
(0 Ulasan)
0.0
macharocho

Hi! See my private message.

$100 USD dalam 2 hari
(0 Ulasan)
0.0
CrixDev

Software engineer with degrees in computer and electrical engineering. Fluent in MySQL and willing to optimize for your current and future situations. Please contact me for quick turnaround.

$100 USD dalam 2 hari
(0 Ulasan)
0.0
kamarasta

sir ... im ready for it, and please read your PMB thanks

$100 USD dalam sehari
(0 Ulasan)
0.0
tfnyldrm

Please check the PM.

$250 USD dalam 2 hari
(0 Ulasan)
0.0
nwspartners

GETTING PROJECTS DONE UNDER BUDGET! New World Solutions brings together some of the brightest minds in the information technology field. From our pool of multi talented, savvy, goal oriented professionals, we s Lagi

$90 USD dalam 2 hari
(0 Ulasan)
0.0