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.