Käynnissä

Mysql speed up routines

Hello,

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 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, expert sql

About the Employer:
( 4 reviews ) Den Haag, Netherlands

Projektin tunnus: #466407

Myönnetty käyttäjälle:

akiladesign

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)
1.4

7 freelanceria on tarjonnut keskimäärin 57 $ tähän työhön

jacekphp

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)
6.8
zub

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

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

Please see PMB for details. Thanks

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

I can help you handle this

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

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)
0.0