Query Monitor showing slow queries with wordpress core

  • Hi,

    I have downloaded Query Monitor because the product list/product pages in the backend take a while to load/update. I have loaded a product in the back-end and the query monitor brought up 3 queries that are slow to load.

    The first one takes over 2 seconds to load:
    Query:
    SELECT DISTINCT meta_key
    FROM wpvq_postmeta
    WHERE meta_key NOT BETWEEN ‘_’
    AND ‘_z’
    HAVING meta_key NOT LIKE ‘\\_%’
    ORDER BY meta_key
    LIMIT 30

    Caller: –
    meta_form()
    wp-admin/includes/template.php:698
    post_custom_meta_box()
    wp-admin/includes/meta-boxes.php:760
    do_meta_boxes()
    wp-admin/includes/template.php:1345

    The second one takes over 1.5 seconds

    Query:
    UPDATE wpvq_postmeta
    SET meta_value = ‘1595717115:1’
    WHERE post_id = 202567
    AND meta_key = ‘_edit_lock’

    Caller:
    update_metadata()

    Does anyone know how to make these queries run faster, or could link me anything that explains how to tackle this?

    Thanks

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    Meta queries are notoriously inefficient. It becomes problematic when there are a lot of posts which need to be queried by meta values. Where frequent meta queries are anticipated over large amounts of data, it’s best to utilize a custom table instead of meta values. (a separate column for each different meta key currently used) Queries using such a table are easier to optimize. If you already have a lot of data using meta values, it’s not trivial to convert to a custom table.

    It might be possible to better optimize the existing table schema. Database optimizations are outside my skill set, so I have little idea how this might be accomplished. Something about optimal keys and indexes I think. Using a different DB engine or bringing in more computing power could help. Get the recommendations of someone who is a true expert in DB optimization before committing to doing anything along these lines.

    If the same queries are run multiple times, it might be advantageous to cache the results in order to avoid re-querying for the same data.

Viewing 1 replies (of 1 total)
  • The topic ‘Query Monitor showing slow queries with wordpress core’ is closed to new replies.

Tags