How many posts/pages/CPT's can WordPress handle without taking a performance hit?

How big a database can WordPress handle without slowing down, getting inefficient, etc.?

Can WordPress handle well a site that has 1,000 – 2,000 posts, pages, CPTs?

Thanks!

Laura

  • Vinod Dalvi
    • WP Unicorn

    Hi Laura,

    I hope you are well today and thank you for your question.

    Yes WordPress can handle well a site that has 1,000 – 2,000 posts, pages, CPTs.

    WordPress, in itself, does not impose any limits on how many Pages or Posts you can publish. In theory, you could have millions. In reality, however, a great deal depends upon your current server and its configuration, load & performance. If the site is still growing, then I’d suggest that you need to start looking at a dedicated server now (if you aren’t already on one) so that you prepared for when the site does start to become sluggish.

    Also see the answer provided in the following reply.

    http://wordpress.stackexchange.com/a/98679/14347

    You can use the following solutions to optimize your WordPress site.

    https://premium.wpmudev.org/project/wp-smush-pro/

    https://premium.wpmudev.org/blog/speed-up-wordpress-caching-plugins/

    https://premium.wpmudev.org/blog/optimizing-your-wordpress-database-a-complete-guide/

    https://wordpress.org/plugins/wp-optimize/

    http://codex.wordpress.org/WordPress_Optimization#Cleaning_Your_Database

    http://codex.wordpress.org/WordPress_Optimization/WordPress_Performance

    Please advise if you have more questions.

    Cheers,

    Vinod Dalvi

  • Laura
    • Design Lord, Child of Thor

    Thanks, Vinod.

    The site is for a non-profit, and I think a dedicated server is out of the question.

    Right now, the site is pure html with a blog on WordPress.com. It’s large, but not highly-trafficked.

    I could suggest that they leave some of the pages as html. Do you think this is necessary/desirable so we don’t need a dedicated server?

    I’d like to move the blog entries to the site once I convert the site to WordPress — so I can have a nice, universal search, among other reasons.

    Do you think I can do this without needing a dedicated server?

    Thanks again Vinod!

    Laura

  • Laura
    • Design Lord, Child of Thor

    Also, one of the articles linked to in Vinod’s response said that:

    A large database can greatly affect the performance of your website as it takes longer for your server to retrieve information from database tables.

    I’d like to have a sense of when this starts to happen and when the problem gets more severe.

    Thanks,

    Laura

  • Jack Kitterhing
    • Code Norris

    Hi there @laura,

    Hope you’re well today and thanks for your question! :slight_smile:

    How many pages and posts does the site have currently? What sort of hosting budget would you have? While a dedicated server may be out of the question, you could get more performance from a VPS server.

    A large database can greatly affect the performance of your website as it takes longer for your server to retrieve information from database tables.

    I’d like to have a sense of when this starts to happen and when the problem gets more severe.

    While that is technically true, it also depends on the server software and con figuration, there are multiple factors that would make it near impossible to say.

    Personally I had a site with 3000 posts on a standard shared host and saw no noticeable slow down, though concurrent visits were low (around 20-30 at any one time).

    If your going to have a high number of concurrent visits, say 1000, a shared host most likely wouldn’t be able to handle that without noticeable slow down or breaking the limits shared hosts regularly set on usage.

    Other things you may want to look into our managed hosts, for example WPEngine, they base their plans on “visits”, if you go over these visits, you get charged ex amount per visit and pay the overage, this is better than shared hosts whereas they’d take down the site temporarily so to not effect other customers, WPEngine would actually scale up and handle those extra visits.

    You could also look into load balancing and CDN’s, a content delivery network, helps massively with the speed of offloading static assets such as images and media.

    Thank you!

    Kind Regards

    Jack.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.