Loop Loading Time with 10,000s of posts?

  • mattmatt88

    (@mattmatt88)


    11 years, 7 months ago

    Hello,

    I’ve got a multisite with three blogs, each of them with thousands of posts. Loading time is ok on static pages. But if there is a posts loop on the page, the loading is very slooow.

    – Is it a good idea to use multisite if each blog has a lot of posts? Does it matter or is it okay, because each blog has its own mysql posts table?

    – Is there anything else I can do to improve the posts loading for the loops? For example, is there a way not to look through all the post table if I just want to get posts of a specific date.

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Christopher Anderton

    (@anderton)

    11 years, 7 months ago

    The loading time depends on the database speed. You can always clean up your database (there are some good posts on the web if you search), or you can use plugins like https://wordpress.org/plugins/wp-optimize/ (note: i haven’t tested the plugin way).

    Regarding getting posts in a specific date (or any other) range, check the codex:
    http://codex.wordpress.org/Template_Tags/get_posts

    Thread Starter mattmatt88

    (@mattmatt88)

    11 years, 7 months ago

    Thank you for your response,

    Clean up the database means deleting unneeded posts, e.g. Spam, unapproved comments etc., the same thing the plugin does? But i need all my 10,000s of posts.

    So is there another way so that a query doesn’t need to always look through the whole posts table, or anything like that?
    So is it a bad idea to have a lot of blogs in a multisite or should I seperate them to improve speed?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 7 months ago

    It’s not about the blogs, it’s about the number of posts on ONE blog.

    Deleting post REVISIONS may help a lot, but when you’re querying 10000 posts to find the ones within specific parameters (dates, etc) it will take a while.

    Maybe try a faster DB server.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Loop Loading Time with 10,000s of posts?’ is closed to new replies.