Very slow backend

Infofuturo García García

• October 17, 2023 10:22

Our backend is loading very slow, we install a plugin to dig into the reason this is happening and the results are the following:

We have a very slow query (3.5 seconds):

SELECT wp_ALLA_posts.ID
FROM wp_ALLA_posts
INNER JOIN wp_ALLA_postmeta
ON ( wp_ALLA_posts.ID = wp_ALLA_postmeta.post_id )
WHERE 1=1
AND ( wp_ALLA_postmeta.meta_key = 'brizy' )
AND wp_ALLA_posts.post_type IN ('post', 'page', 'product', 'xornaes_d_estudiu', 'dia_de_les_lletres', 'tribe_events', 'editor-story', 'editor-popup', 'editor-template', 'editor-story', 'editor-popup', 'editor-template', 'editor-story', 'editor-popup', 'editor-template', 'brizy-layout')
AND ((wp_ALLA_posts.post_status = 'publish'
OR wp_ALLA_posts.post_status = 'draft'))
GROUP BY wp_ALLA_posts.ID
ORDER BY wp_ALLA_posts.post_modified DESC
LIMIT 0, 5

Do you know what the problem is?

This query is from the home page of the wordpress admin.

Thank you in advance.

 

Regards,

0

• 

  Ariel H.

  • October 17, 2023 11:59

  Hi,

  Thank you for reaching out to us.

  Please try to optimize your database and see if this will help.
  https://cyberpanel.net/blog/wordpress-database-optimization/

  Periodically cleaning up your WordPress database by removing unnecessary data can potentially help address this issue.

  Best regards,
  Ariel H.

  0

Please sign in to leave a comment.