WordPress.org

1. paulaeisenberg
   Member
   Posted 2 years ago #

   It's been only a year, and my news site is up to almost 1,000 posts.

   Is there a functional limit to how many posts a WordPress site can really handle? At some point, does the MySQL database choke?

2. Shane G.
   Member
   Posted 2 years ago #

   Hi,

   Check with this plugin:

   http://wordpress.org/extend/plugins/wp-limit-posts-automatically/

   Thanks,

   Shane G.

3. paulaeisenberg
   Member
   Posted 2 years ago #

   Shane, thanks, but that's not what I meant. I mean that as our site grows, the number of posts will continue to grow, and that's a good thing. But I'm worried that at some point, the sheer volume of posts and images could overwhelm the database.

4. esmi
   Theme Diva & Forum Moderator
   Posted 2 years ago #

   In theory, there isn't a limit. In reality, a lot will depend upon the server's performance and how much traffic you're getting (or will get). You might want to look at something like WP Super Cache to try and limit the load on the server.

5. Mark / t31os
   Moderator
   Posted 2 years ago #

   You'd have to go into millions/billions of records before MySQL chokes, the server is likely to choke for other reasons before mysql hits any kind of volume limitation.

   http://dev.mysql.com/doc/refman/4.1/en/features.html
   http://dev.mysql.com/doc/refman/5.1/en/features.html

   See section headed "Scalability and Limits: "

6. paulaeisenberg
   Member
   Posted 2 years ago #

   Thank you, esmi and t310s_. That's good to know.

   I've used WP Super Cache, WP-Cache, Hypercache and DB Cache Reloaded. All of them seem to disrupt some admin functions. Even with no cache plugin running, and even with 230 queries on our front page, the speed seems to hover around 0.9 second. So I guess that isn't too bad. We moved from a slow host to Hostgator recently, and it's been much faster.

Topic Closed

This topic has been closed to new replies.