[Plugin: Related Posts Thumbnails] Optimized performance

  • senator94

    (@senator94)


    12 years, 7 months ago

    I love this plugin but lately I had to turn it off because of performance. I have a site with over 45k unique visitors a day and over 100k pages viewed daily.

    The plugin is set to show 12 thumbs with “tags” as the relationship. My server load shot up to an average 15.00 compared to 1.3.

    I think W3 Total Cache is not chaching the related thumbs hence my server load.

    Is there a way to check if the related thumbnails are being cached?

    http://wordpress.org/extend/plugins/related-posts-thumbnails/

Viewing 1 replies (of 1 total)
  • Summer

    (@fpmsummer)

    12 years, 7 months ago

    Performance is also an issue with a couple of my sites. We have over 22000 articles on one site, and we’ve only got it set to show 3 related posts, using tags and categories. I’ve tuned the settings down to only include posts after Jan 1 2008, but it still hasn’t helped much.

    Not using a caching plugin, but looking at the SQL query being generated, that’s a crazy query:

    SELECT distinct ID FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘publish’ AND ID<>19714 AND post_date >= ‘2008-01-01’ AND ID IN (obnoxiously long list of nearly 15000 individual post IDs) ORDER BY rand() LIMIT 3;

    I’ve seen that query take anywhere from 3 to 25 seconds. Not good.

    I’m open to a solution, because I also love this plugin. Adore it, even.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Related Posts Thumbnails] Optimized performance’ is closed to new replies.