WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Yet Another Related Posts Plugin] Slight SQL improvement suggestion (2 posts)

  1. Pinoy.ca
    Member
    Posted 4 years ago #

    Hello mitcho,

    I experienced a good improvement to client-side pageload times by adding score and date to the related cache primary key:

    ALTER TABLE wp_yarpp_related_cache DROP PRIMARY KEY ,
    ADD PRIMARY KEY ( score , date , reference_ID , ID )

    in this order. It essentially removes the table fetch (adds using index) in the SQL for yarrp_cache_enforce and removes the using filesort pass (and adds using index) in the SQL for get_posts. Faster all around.

    Just an FYI. Happy Holidays.

    http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/

  2. Thanks Pinoy! I've added this to my latest beta, 3.1.3b2:

    http://downloads.wordpress.org/plugin/yet-another-related-posts-plugin.3.1.3b2.zip

    Happy Holidays. :)

    mitcho

Topic Closed

This topic has been closed to new replies.

About this Topic