3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

Will having too many posts on my website make it slow? (10,000+)

by saxguru
2 replies
Hi all,

I am wondering if having over 10,000 posts on my website will make it very slow? Will I have to upgrade my hosting?

I have multiple sites on the same hosting which could all potentially have this number of posts. Each post if for an individual product, hence the large number of posts.

Thanks
#make #posts #slow #website
  • Profile picture of the author jeffatrackaid
    I assume this is a Wordpress site based on your signature?

    Performance is primarily impacted by the number of requests/min not by the number of posts. If you have a 1,000,000 posts but nobody views them -- you don't have a web performance issue.

    Imagine an excel spreadsheet ... if you are trying to find 1 row (post) in 10,000 it is going to take a little longer than 1 row in a 100. This is basically what your database is doing when it looks up a post. Unless you are using budget-shared hosting, I would not expect much different between 1 post or 10,000.

    Lastly, if these posts are mostly static, consider using WP Super Cache. That will create a HTML version of the page and cache it on your disk. This way your database is not involved.

    I use that tool on some WP server I mange getting millions of page views a day and it works wonders for performance.

    If that still does not give you what you need, check into Cloudflare's optimization services but be careful with any affiliate tracking gods.
    {{ DiscussionBoard.errors[8949315].message }}
    • Profile picture of the author saxguru
      Originally Posted by jeffatrackaid View Post

      I assume this is a Wordpress site based on your signature?

      Performance is primarily impacted by the number of requests/min not by the number of posts. If you have a 1,000,000 posts but nobody views them -- you don't have a web performance issue.

      Imagine an excel spreadsheet ... if you are trying to find 1 row (post) in 10,000 it is going to take a little longer than 1 row in a 100. This is basically what your database is doing when it looks up a post. Unless you are using budget-shared hosting, I would not expect much different between 1 post or 10,000.

      Lastly, if these posts are mostly static, consider using WP Super Cache. That will create a HTML version of the page and cache it on your disk. This way your database is not involved.

      I use that tool on some WP server I mange getting millions of page views a day and it works wonders for performance.

      If that still does not give you what you need, check into Cloudflare's optimization services but be careful with any affiliate tracking gods.
      Thanks for the insight. I'm using shared hosting with Vidahost but I have upgraded it from the usual hosting packages. I may have some problems down the line but I have the option to upgrade with a few clicks so hopefully I won't have too many issues

      thanks for the help
      {{ DiscussionBoard.errors[8949746].message }}

Trending Topics