WordPress.org

Ready to get started?Download WordPress

Forums

Can WordPress have too many posts? (19 posts)

  1. ezinestein
    Member
    Posted 9 years ago #

    Hi,

    If a blog grows too big... will things load very slowly when people arive at the blog. By big... I mean many many posts in the database.

    kindly,
    ez

  2. If a blog grows too big... will things load very slowly when people arive at the blog.

    Only if, by some odd reason, you have chosen to show all posts on the index page of your blog.

  3. masquerade
    Member
    Posted 9 years ago #

    In case anyone was wondering, the current max number of posts you can have on a webserver with a 32-bit processor, its:

    340282366920938463463374607431768211456

  4. popstat
    Member
    Posted 9 years ago #

    Damn, I'd better slow down my daily blogging before I hit that threshold...

    But seriously, that is a concern, especially with load time. Big reason I chose WP over MT is the dynamic page creation, eliminating the load/rebuilds found in MT blogs.

  5. angsuman
    Member
    Posted 9 years ago #

    Some plugins with complex unoptimized queries may cause slow down.

  6. pizdin_dim
    Member
    Posted 9 years ago #

    masquerade: I thought that "post_ID" is currently defined in the database as "bigint(20) unsigned" and it's range was from 0 to 18446744073709551615. How did you calculate 340282366920938463463374607431768211456?

  7. RustIndy
    Member
    Posted 9 years ago #

    340282366920938463463374607431768211456 would just be the physical limit based on the processor's type handling. If the WP code limits it to 20 bits (as opposed to 32 bits), then 18446744073709551615 *is* the maximum number of posts in a single WordPress blog.

  8. masquerade
    Member
    Posted 9 years ago #

    mmm, I forgot that it was set as bigint(20), I was just remembering that is an unsigned integer, which can be up to the max integer value in C, which is 2^128 iirc.

  9. Kafkaesqui

    Posted 9 years ago #

    "then 18446744073709551615 *is* the maximum number of posts in a single WordPress blog"

    Man, that's just not enough!

  10. RustIndy
    Member
    Posted 9 years ago #

    That might be a truer statement than you know. If you're currently young (say early twenties or less), there's a fair chance that by the time you reach 60, medical technology will have extended lifetimes by up to 100%. By the time you reach 100 (and still hale and hearty), that will be extended by another 100 years. Finally, when you're around 160 or so, computer technology will have caught up and you'll have the option of copying yourself to an electronic form - just in case the age-reduction treatments fail :) And if they do fail and you wake up dead instead of 25, just wait another 100 years for them to be able to grow you a stub body cloned from your original.

    So if you think about it, 18446744073709551615 posts becomes more possible with each passing year.

  11. Kafkaesqui

    Posted 9 years ago #

    I think I'd be smarter to worry about things closer to likelyhood, like that UNIX era thing biting me in the butt...

  12. pizdin_dim
    Member
    Posted 9 years ago #

    RustIndy: Good one. Do you reckon WordPress might be obsolete by then?

  13. RustIndy
    Member
    Posted 9 years ago #

    I think there'll always be an upgrade path. Besides, by the time you make it to post number 18446744073709551616, that won't be the limit anymore ;)

    Unless, of course, you're running your galactinet server on an antique computer ;)

  14. Kafkaesqui

    Posted 9 years ago #

    Don't forget the beauty of the neural interface plugin. Speeds up time to post immeasurably.

  15. then 18446744073709551615 *is* the maximum number of posts in a single WordPress blog.

    Will WordPress v1.6 provide support for 190000000000000000+ posts?

  16. Jonathan Dingman
    Member
    Posted 9 years ago #

    Popstat or anyone: if your'e really worried about the load time, use the plugin called staticize or a similar plugin that will cache the template and pages so the load is easier on the server.

  17. Mark (podz)
    Support Maven
    Posted 9 years ago #

    I moved a database recently.

    The complete size was in excess of 200MB
    Of that though, around 140MB was accumulated stats. The rest was posts/comments.

    Very popular blog and there was no slowdown at all.

  18. skippy
    Member
    Posted 8 years ago #

    Databases are remarkably good at managing the data inside them. Even if you have hundreds of thousands of posts, MySQL should not have any real difficulty selecting the bits necessary for each individual page.

  19. Kafkaesqui

    Posted 8 years ago #

    "Databases are remarkably good at managing the data inside them."

    It is sort of their claim to fame, isn't it. :)

Topic Closed

This topic has been closed to new replies.

About this Topic