Is there a limit to number of posts WP can handle?

Hi,

Check with this plugin:

https://www.ads-software.com/extend/plugins/wp-limit-posts-automatically/

Thanks,

Shane G.

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.

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.

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.

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

See section headed “Scalability and Limits: ”

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.