WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Popular Posts
Cache WordPress Popular Posts queries (5 posts)

  1. andreu
    Member
    Posted 3 years ago #

    Hi!

    I have a little problem with the plugin. It seems that the results it shows are not in cache at all. I mean, every time someone visits my website, a quite long query is executed. Since I'm receiving a lot of visits last months I'm having troubles with my server, which could not process all the queries when I have some simultaneous visits.

    The query that is launched every time is long and a bit difficult to understand:

    SELECT wp_posts.ID, wp_posts.post_title, (
    SUM( wp_popularpostsdatacache.pageviews )
    ) AS 'pageviews'
    FROM wp_posts
    RIGHT JOIN wp_popularpostsdatacache ON wp_posts.ID = wp_popularpostsdatacache.id
    WHERE wp_posts.post_status = 'publish'
    AND wp_posts.post_password = ''
    AND wp_popularpostsdatacache.day = CURDATE( )
    AND wp_posts.post_type = 'post'
    AND wp_posts.ID NOT
    IN (
    
    SELECT object_id
    FROM wp_term_relationships AS r
    JOIN wp_term_taxonomy AS x ON x.term_taxonomy_id = r.term_taxonomy_id
    JOIN wp_terms AS t ON t.term_id = x.term_id
    WHERE x.taxonomy = 'category'
    AND object_id
    IN (
    
    SELECT object_id
    FROM wp_term_relationships AS r
    JOIN wp_term_taxonomy AS x ON x.term_taxonomy_id = r.term_taxonomy_id
    JOIN wp_terms AS t ON t.term_id = x.term_id
    WHERE x.taxonomy = 'category'
    AND t.term_id
    IN ( 4, 6, 11, 1070 )
    )
    )
    GROUP BY wp_posts.ID
    ORDER BY pageviews DESC
    LIMIT 10

    In my site, I'm showing three lists of most popuplar post with the following functions:

    Daily:

    <? wpp_get_mostpopular('order_by="views"&range="daily"&header=""&header_start=""&header_end=""&pages=0&stats_comments=0&cats_to_exclude="4,6,7,11,1070"&post_start="<li>"&post_end="</li>"&wpp_start="<ol>"&wpp_end="</ol>"&limit=10'); ?>

    Weekly:

    <?php wpp_get_mostpopular('order_by="views"&range="weekly"&header=""&header_start=""&header_end=""&pages=0&stats_comments=0&cats_to_exclude="4,6,7,11,1070"&post_start="<li>"&post_end="</li>"&wpp_start="<ol>"&wpp_end="</ol>"&limit=10'); ?>

    Monthly:

    <?php wpp_get_mostpopular('order_by="views"&range="monthly"&header=""&header_start=""&header_end=""&pages=0&stats_comments=0&cats_to_exclude="4,6,7,11,1070"&post_start="<li>"&post_end="</li>"&wpp_start="<ol>"&wpp_end="</ol>"&limit=10'); ?>

    Can anyone give me any advice about this? How could I cache this query? I'm already using W3 Total Cache plugin for the the general queries and more things but it seems that is not working well with this query.

    Any advice will be really appreciated. Thanks in advance and good work with this two awesome plugins! :)

    http://wordpress.org/extend/plugins/wordpress-popular-posts/

  2. Klark0
    Member
    Posted 3 years ago #

    that plugin is very bad on my large site. Lots of queries, i think it tries to catch results.

    So i dropped it, and used the functions that already exist in the wp.com stats plugin.

  3. Frederick Townes
    Member
    Posted 3 years ago #

    What settings are you using? Can you paste them here using paste bin or submit a bug submission form from the support tab of the plugin?

  4. andreu
    Member
    Posted 3 years ago #

    Hi Frederick,

    Here is a link to my W3 Total Cache settings in Paste Bin: http://pastebin.com/4mPxtVt0

    Thanks!

  5. Frederick Townes
    Member
    Posted 3 years ago #

    Have you checked database debug mode to see if you can identify the query in question? Also, there is a topic here somewhere (they are hard to search for), where users have overcome this concern before.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic