Slow Add/Edit Page/Post Pages on Dashboard

  • Hi, I have a website with 328k users. When I am accessing the Add/Edit Page or Add/Edit Post page, it triggers a query, which is very slow.

    SELECT wp_users.ID,wp_users.user_login,wp_users.display_name
FROM wp_users
INNER JOIN wp_usermeta
ON ( wp_users.ID = wp_usermeta.user_id )
WHERE 1=1
AND ( ( ( ( wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%\"edit\\_posts\"%' )
OR ( wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%\"administrator\"%' )
OR ( wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%\"editor\"%' )
OR ( wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%\"author\"%' )
OR ( wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%\"contributor\"%' )
OR ( wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%\"shop\\_manager\"%' ) ) ) )
ORDER BY display_name ASC

    Is there any way to avoid getting this query triggered as it seems like WordPress is not built, considering the high number of users on the website?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Sanchit Varshney

    (@sanchitvarshney)

    Here’s a Image of Query Monitor showing the query with time it is taking.

    Could you have a look in the Query Monitor, where you took the screenshot, where this query is generated?

    By the way, I currently have an online shop with over 30,000 customers and have no such problems loading. There may also be a problem with your database server or database indices are missing / not up to date.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Slow Add/Edit Page/Post Pages on Dashboard’ is closed to new replies.