query examines 57753 rows, which is unacceptable in shared hosting.

  • Please may some help with a query problem listed below. I am not that technical savvy, so i have no idea what this is all about. thanx
    Problematic query:
    SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status = ‘publish’ AND post_type IN (‘post’) AND term_taxonomy_id = 1

    EXPLAIN:
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE wp_term_relationships ref PRIMARY,term_taxonomy_id term_taxonomy_id 8 const 57753
    1 SIMPLE wp_posts eq_ref PRIMARY,type_status_date PRIMARY 8 afr1110102051989.wp_term_relationships.object_id 1 Using where

    This query examines 57753 rows, which is unacceptable in shared hosting.

  • The topic ‘query examines 57753 rows, which is unacceptable in shared hosting.’ is closed to new replies.

Tags