• Resolved OC2PS

    (@sooskriszta)


    What’s the trigger for getting related posts?

    Most related post plugins build the list of related posts on the fly when the user needs to view it. Since blogs tend to be viewed far more often than they are updated (often hundreds of times more often), these queries are run way more times than they need to be. This not only wastes CPU cycles, but if the queries are slow (which they will be if you have 1000s of posts and tags) then the user gets a poor experience from slow page loads.

    Would be nice if this plugin moves all this effort into the admin section, finding related posts when a post is saved rather than when the user views it. The advantage is that if the query is slow it happens less often and the post writer is the one that waits rather than the user (which I think is WAY better).

    At the time of saving a post, find all the posts related to the one being saved, and if the current post is more closely related to one of those posts than the least related post that is currently stored, you re-process that post.

    http://wordpress.org/extend/plugins/spostarbust/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Eli

    (@scheeeli)

    My plugin builds related posts on the fly. As you say, most of them do. That is because it is relatively easy to do and the posts that are returned from the query can differ depending on what other posts are on the page. Do you have a site with thousands of posts, and would you be willing to measure the query times and overall performance drop (My largest blog has only 260 posts but I see no performance drop myself)?

    The idea of predetermining related posts is a good one. It would take a lot of retooling my code to do all the processing in the admin rather than on the fly. Are there any other free related post plugins that you know of that do this well?

    I have made this plugin completely free so far and donated all my time in making it (and making it better). Do you think that this would be an improvement that would be worth something to some people and that they might be willing to pay for a “pro” version that incorporates this feature?

    Thanks for taking the time to leave me this feedback.
    Aloha, Eli.

    Thread Starter OC2PS

    (@sooskriszta)

    Well, I do feed the performance impact with a few hundred posts. It could be due to the fact that I am using shared hosting like most WordPress users.

    My host throttles the number of queries per hour, so running queries for every display is frought with risk.

    Add to that the fact that there are other items such as NextGen Gallery, bbPress and BuddyPress vvying for the limited queries…you get the idea.

    The idea about triggering related posts calculation on save is a very good one. Not mine, though. I got it from a recently deceased plugin http://wordpress.org/extend/plugins/efficient-related-posts/ and in fact plagiarised part of my OP from that plugin’s description.

    The last update for the plugin was 2 months ago. That’s not bad, but the problem is that it doesn’t seem to work with latest version of WordPress. Moreover, the author seems to have abandoned it, or at least is not supporting it anymore – have a look in the forum and you can see there has been no activity from the author for several months.

    Perhaps you could take over that plugin or incorporate some of its code in yours?

    Plugin Author Eli

    (@scheeeli)

    If you really feel the performance impact from one extra query I would suggest looking into better hosting for your site.

    My plugin does a fair job of dynamically generating Related Post Links. There are so many advantages to having these links stay dynamic. So, I have decided not to turn my plugin into something it was never intended to be.

    If what you really want is efficient-related-posts, and it’s broken, then you should contact aaroncampbell and get him to fix it. Or maybe a more wholistic approach to your general issue is to use an plugin like WP Super Cache, then you don’t have to worry about all those other plugins running queries either.

    In any case, I hope you find what you are looking for. I am marking this topic as “Resolved”.

    Aloha, Eli

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: ELI's Related Posts Footer Links and Widget] Trigger for related posts’ is closed to new replies.