When clicking Quiz Attempts CPU usage is increasing to 100%

Dear Concern,

We apologize for the issue you’re experiencing. It appears to be a website-specific problem and to properly diagnose and resolve it, we would need to thoroughly inspect your website. Please reach out to us at?https://www.themeum.com/support/?for assistance.

i raised email to themium support but no response

also created a chat and no response

Dear Concern,

We have replied, please check your email.

Thank you.

Here’s the query that causing the High CPU Usage

i find the query using ” ?Index WP MySQL For Speed” Plugin

SELECT DISTINCT quiz_attempts.*, quiz.post_title, users.user_email, users.user_login, users.display_name
FROM fgt_tutor_quiz_attempts quiz_attempts
INNER JOIN fgt_posts quiz ON quiz_attempts.quiz_id = quiz.ID
INNER JOIN fgt_users AS users ON quiz_attempts.user_id = users.ID
INNER JOIN fgt_posts AS course ON course.ID = quiz_attempts.course_id
INNER JOIN fgt_tutor_quiz_attempt_answers AS ans ON quiz_attempts.attempt_id = ans.quiz_attempt_id
WHERE quiz_attempts.attempt_ended_at IS NOT NULL
AND ( users.user_email = '' OR users.display_name LIKE '%%' OR quiz.post_title LIKE '%%' OR course.post_title LIKE '%%' )
AND quiz_attempts.attempt_ended_at IS NOT NULL
ORDER BY quiz_attempts.attempt_ended_at DESC
LIMIT 20 OFFSET 0

• This reply was modified 12 months ago by itsmejomijohn.

how to solve this error