WordPress.org

1. Pinoy.ca
   Member
   Posted 2 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. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 2 years ago #

   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.