WordPress.org

Ready to get started?Download WordPress

Forums

ELI's Related Posts Footer Links and Widget
[resolved] Questions about queries and scalability (4 posts)

  1. skippybosco
    Member
    Posted 2 years ago #

    Hello,

    Thank you for making this plugin available. Looks great.

    I have a site with 30,000+ posts that I am considering using this plugin on. Is there consideration in the code to limit the impact of the queries to the server?

    In looking at the code it looks like you are building a query similar to this:

    GET {NUM} POSTS WHERE TAG = {TAG# or TAG# or ...} ORDER BY {SORT CONFIGURATION}

    I wanted to check with you on how it is limiting the amount of data being processed / sorted to minimize impact on the database and web server?

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

  2. Eli
    Member
    Plugin Author

    Posted 2 years ago #

    I did not write it specifically for "Ginormous" (made-up word) sites, nor have I tested it on such sites myself. However, the query is fairly clean and it limits the number results according to the number of Related Links you specify in the settings.

    Let me know how it works for you.

    Aloha, Eli

  3. skippybosco
    Member
    Posted 2 years ago #

    Thanks for the quick reply Eli.

    What I was mostly curious about is how the query was limiting the number of results.

    In looking at the code a bit deeper it looks like this is the main query which is just using the wp native showposts query:

    showposts => $number, $relateby => $tag_IDs, 'post__not_in' => $SPOSTARBUST_POP, 'tag__not_in' => $SPOSTARBUST_settings_array['exclude__intags'], 'category__not_in' => $SPOSTARBUST_settings_array['exclude__incategories'], 'orderby' => $SPOSTARBUST_settings_array['orderby'], 'order' => $SPOSTARBUST_settings_array['order']);

    We're running a different test right now on the site, but when that completes next week I'll give this a go and see how it looks.

  4. skippybosco
    Member
    Posted 2 years ago #

    Following up to provide update of the plugin running on a Ginormous site.. 2 days in and seems to be fairly non impacting, great job!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.