Mysql speed up routines


We have two websites. On website one the execution of a large routine takes about 1 second.

Now we had an other programmer use the same data to create a smaller query (with the same data) and on a smaller database. This query takes over 7 seconds to generate.

This is of course not meant to be only the current programmer has sufficient experience to solve it.

I've attached the current (slow) file.

If you are a MySql expert, please respond.

Any questions? Please PM

Thanks for bidding.

Taidot: PHP, SQL

Näytä lisää:, sql programmer expert, programmer mysql, Mysql questions, mysql php query speed, php mysql speed, sql mysql, speed up , speed up data, slow speed, mysql query, Mysql expert, execution, mysql query slow, bidding query php, mysql query php, mysql slow, database speed, speed slow, expert sql questions, routine, create mysql, php query mysql, use php query database, generate query

Tietoa työnantajasta:
( 4 arvostelua ) Den Haag, Netherlands

Projektin tunnus: #466407

Myönnetty käyttäjälle:


Hello, We are web development company with a lot of experience in MySQL. We can do this for you fast and effieciently. Hope to work togheter on this project. AkilaDesign Team.

$50 USD 1 päivässä
(1 arvostelu)

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


Hello, script is unprofessionally written. First of all it is not safe. If only someone is capable eneough then can take control of your database easily, even destroy it(SQL Injection attack). Another thing is not Lisää

$70 USD 1 päivässä
(19 arvostelua)

Hello Sir, Please see the PM. Thank you. With regards Zub

$75 USD 1 päivässä
(47 arvostelua)

Please see PMB for details. Thanks

$65 USD 1 päivässä
(1 arvostelu)

I can help you handle this

$30 USD 1 päivässä
(7 arvostelua)
$80 USD 1 päivässä
(0 arvostelua)

Hi, I am A Certified MySQL DBA and developer. optimizing queries comes in my job role. I can do this in no time. but i have some queries please check PM regards roshan.

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