Costruire Siti Web

已完成 已发布的 7 年前 货到付款
已完成 货到付款

My phpbb 3.1. is suffering slowness due to session table.

I need someone who can optimized the query

SELECT u.*, s.session_time, s.session_viewonline, s.session_start, s.session_page, session_forum_id

FROM phpbb_users u

LEFT JOIN (

SELECT u.user_id, MAX(s.session_time) as session_time, MIN(s.session_viewonline) AS session_viewonline, session_start, session_page, session_forum_id

FROM phpbb_users AS u

LEFT JOIN phpbb_sessions AS s ON u.user_id = s.session_user_id

WHERE u.user_id = '1'

group by u.user_id, session_start, session_page, session_forum_id

) s on u.user_id = s.user_id

WHERE u.user_id = '1'

ORDER BY session_time DESC\G

Please only very professional and expert. Thanks

MySQL

项目ID: #12303396

关于项目

4个方案 远程项目 活跃的7 年前

授予:

justTry

Hello! This is something you wrote or some extension? Because if it was you then I have some questions to assess what's the actual aim(desired outcome) of it. It does look like some core queries of phpbb but not in 更多

$30 USD 在0天内
(73条评论)
5.5

有4名威客正在参与此工作的竞标,均价$96/小时

skSolutionz1

Hi, The project details are cleared and I am up for it to begin it right away. Please revert back in order to chat further. Allow me a chance to work on your project and I assure you that I won't let you down. 更多

$77 USD 在3天内
(0条评论)
0.0