Costruire Siti Web
$30-250 USD
货到付款
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
项目ID: #12303396
关于项目
有4名威客正在参与此工作的竞标,均价$96/小时
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. 更多