• Hi

    All of a sudden we have started having issues with this plugin.

    We are on version 1.1.

    Categories pages are having load times of beyond 40 seconds and sometimes cause the entire server to crash.

    The issue seems to be related to this query:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    LEFT JOIN wp_term_relationships
    ON (wp_posts.ID = wp_term_relationships.object_id)
    LEFT JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id
    AND wp_postmeta.meta_key = '_whp_hide_on_categories' )
    WHERE 1=1
    AND ( wp_term_relationships.term_taxonomy_id IN (332) )
    AND ( wp_postmeta.post_id IS NULL )
    AND ((wp_posts.post_type = 'post'
    AND (wp_posts.post_status = 'publish'
    OR wp_posts.post_status = 'private')))
    GROUP BY wp_posts.ID
    ORDER BY wp_posts.post_date DESC
    LIMIT 0, 10

    With the plugin disabled the below query completes in 0.05s:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    LEFT JOIN wp_term_relationships
    ON (wp_posts.ID = wp_term_relationships.object_id)
    WHERE 1=1
    AND ( wp_term_relationships.term_taxonomy_id IN (332) )
    AND ((wp_posts.post_type = 'post'
    AND (wp_posts.post_status = 'publish'
    OR wp_posts.post_status = 'private')))
    GROUP BY wp_posts.ID
    ORDER BY wp_posts.post_date DESC
    LIMIT 0, 10

    Ideally we need to keep the plugin but cannot have the site down.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author MartinCV

    (@martin7ba)

    Hi, thank you for bringing this to my attention and very sorry for late reply.

    I am in process of updating the plugin to use a custom table for managing the post visibility. This will be a major update and it requires some more testing before I can release it and I am hoping to have it done by end of this year.

    This update will bring better performances and speed.

    Best,
    Martin

    Plugin Author MartinCV

    (@martin7ba)

    @kingofwebdev There is new version of the plugin that uses custom database table and simplifies the query.

    Can you please update the plugin and let me know if the performance issue is fixed?

    Best regards,
    Martin

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.