Đã hoàn thành

152923 Optimize mysql Query (Large)

I got a mysql query

in php, that does a join on a large table (90GB)

query takes somewhere between 7 and 20 seconds

I need help to speed this up.

I can show the query on the private message board.

You need to be real experiences with mysql, experience with optimizing and tweaking performance.

I think indexes are on the right place, and "explain" shows that they are being used

please basic mysql skills will not be sufficient to solve this problem.

If you are a mysql guru, this should be an easy buck

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: performance board, n query, guru skills, guru message, basic guru, query table, optimize mysql, mysql query, i got a 7, php mysql join table, mysql join table, mysql table join, php mysql optimize, mysql optimizing , mysql help table, query performance, query query, mysql query php, query optimize, performance optimize, mysql join, optimize php mysql, performance problem, query optimize mysql, php mysql table join

Về Bên Thuê:
( 11 nhận xét ) Netherlands

ID dự án: #1899104

Được trao cho:


Hi, I could help you on this one. See PMB for details. Regards, Jeff

$20 USD trong 1 ngày
(17 Đánh Giá)