[Plugin: ELI's Related Posts Footer Links and Widget] Questions about queries and scalability

  • Resolved skippybosco

    (@skippybosco)


    11 years, 9 months 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/

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

    (@scheeeli)

    11 years, 9 months 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

    Thread Starter skippybosco

    (@skippybosco)

    11 years, 9 months 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.

    Thread Starter skippybosco

    (@skippybosco)

    11 years, 9 months 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!

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