1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can wordpress handle 1 Million Posts

Discussion in 'Blogging' started by LongJohn, Aug 2, 2010.

  1. LongJohn

    LongJohn Registered Member

    Joined:
    May 13, 2010
    Messages:
    57
    Likes Received:
    9
    Hi

    I am building a big wordpress blog that will host more that 1 million posts, can wordpress handle so many posts?

    I know that wordpress is resources intensive but it is easy to use not like Drupal, doesn't have to many security problems like Joomla.

    Wordpress 3 and WordPress MU are one project so I think that it can handle the load, but some say that they have problems with a big blog.

    I plan to use only one plugin the super cache

    Tell me what you have experienced having a big wordpress blog or if you have a better alternative
     
  2. Quo_Vadiz

    Quo_Vadiz Regular Member

    Joined:
    Mar 12, 2010
    Messages:
    259
    Likes Received:
    47
    i got a wordpress website with 20k post and uses a lot of memory
    u can give it a shot but u will need a good server
     
  3. -Jericho-

    -Jericho- Jr. Executive VIP Jr. VIP Premium Member

    Joined:
    Jan 10, 2010
    Messages:
    2,849
    Likes Received:
    1,704
    Location:
    Stalking My Ex-Wife
    This probably more of a hosting question than a wordpress question. 1M posts is going to take up a lot of memory and CPU usage especially if you get a lot of traffic. Make sure to use a program like WP Super Cache
     
  4. iq465

    iq465 Regular Member

    Joined:
    Sep 12, 2009
    Messages:
    276
    Likes Received:
    58
    Occupation:
    Graphic Designer / Record Label
    Location:
    Chicago
    Home Page:
    Jericho is correct, with a dedicated server and a caching system you might squeeze by
     
  5. LyNHS

    LyNHS Regular Member

    Joined:
    Jul 20, 2010
    Messages:
    282
    Likes Received:
    98
    Occupation:
    Google AdSense
    Home Page:
    Handling 1 million posts certain will take it's toll!

    If you get yourself a strong dedicated server, with something like 16GB of RAM, and 1TB of Data, you shouldn't have any problems ... when you start to experience problems, that's when you need to build a clustered environment - which is basically multiple servers connected as one - that's what the big sites like eBay etc do.

    What you need to consider is your visitors experience. A lagging site isn't fair for anyone; so even though you may be able to fit it all on a server, WordPress may have a job displaying all the posts etc ...

    As for managing a million posts; wow, that's another question!

    Hope that helps,
    Lynn.
     
  6. corbin2

    corbin2 Registered Member

    Joined:
    Jan 16, 2010
    Messages:
    66
    Likes Received:
    41
    Wordpress never works well with a huge database. It will require a lot of hardware resources. You should look into other options. Drupal for example is not that hardware hungry. But 1 million is real much... for any CMS.
     
  7. Gibbzee

    Gibbzee Regular Member

    Joined:
    Jun 17, 2009
    Messages:
    399
    Likes Received:
    142
    1 million posts? wow. They must have taken you along time to write.
     
  8. wpbacklinks

    wpbacklinks Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 27, 2010
    Messages:
    3,397
    Likes Received:
    1,339
    Gender:
    Male
    Occupation:
    Affiliate Marketer
    Location:
    Everywhere
    1 million posts? don't host your site on shared server, buy dedicated!!
     
  9. LongJohn

    LongJohn Registered Member

    Joined:
    May 13, 2010
    Messages:
    57
    Likes Received:
    9
    I will try wordpress, I have no other choice I will have to see how many post can it handle, hopefully it will run smoothly with at least 500k
     
  10. trapmuzik

    trapmuzik Junior Member

    Joined:
    Mar 20, 2009
    Messages:
    192
    Likes Received:
    22
    if you plan on adding all that over time make sure you optimize the db posts and postmeta tables daily and allocate enough mem to mysql. a db of that size will take a few seconds to find posts and display them. WP Supercache is your best bet for frequently accessed pages.
     
  11. gorang

    gorang Elite Member

    Joined:
    Dec 6, 2008
    Messages:
    1,891
    Likes Received:
    1,650
    Occupation:
    SEO Consultant - Marketing Strategy
    Location:
    UK
    1 Million articles eh? In what niche?

    wouldn't be suprised if the people replying here find articles form their own sites scraped on this guy's site.
     
  12. seoitright

    seoitright Regular Member

    Joined:
    May 12, 2010
    Messages:
    253
    Likes Received:
    23
    Location:
    Out There!
    I have a wordpress article site with 24k posts on a dedicated server and it does take a lot of memory and that's on a dedicated, I have been thinking about taking it down. You gonna need a big dedicated to handle 1 mil without problems, the database will be huge!!
     
  13. LongJohn

    LongJohn Registered Member

    Joined:
    May 13, 2010
    Messages:
    57
    Likes Received:
    9
    seoitright what hosting company do you use for that blog, I have one with 25k that runs smoothly, with no problems.

    gorang you won't find any articles from our friends on this blog, on other smaller blogs maybe ;)
     
  14. caroline42

    caroline42 Junior Member

    Joined:
    Mar 14, 2010
    Messages:
    156
    Likes Received:
    19
    Occupation:
    Search engine optimizer
    Location:
    Spain
    You need a good server and should use PostgreSQL DB instead of MySQL
     
  15. BlackxHat

    BlackxHat Power Member

    Joined:
    Oct 6, 2009
    Messages:
    591
    Likes Received:
    78
    So i guess youre good with a dedicated server and wordpress, How much will that cost and which do u recommend?
     
  16. LongJohn

    LongJohn Registered Member

    Joined:
    May 13, 2010
    Messages:
    57
    Likes Received:
    9
    LyNHS said that I need 16G of RAM that will cost $600 a month, that is to much I will use a shared server for as long as I can, and if I make some money then I will upgrade.

    But if one wp can't handle enough posts I will install more wp rather that upgrading to a bigger server
     
    Last edited: Aug 2, 2010
  17. PlatinumPi4u

    PlatinumPi4u Junior Member

    Joined:
    Mar 5, 2010
    Messages:
    168
    Likes Received:
    29
    Talk with your hosting - the kind of hosting that is quick to respond to your needs.... Go dedicated / semi dedicated. My hosting gives you 100/mb a month, and charges like $3/mo for each additional 100mb of mysql - Caching will zap your CPU usage, so be weary of that until you see actual stat numbers if you are expecting a large volume of traffic.

    I don't see handling that many posts as a big problem -
     
  18. verilix

    verilix Jr. VIP Jr. VIP

    Joined:
    Sep 18, 2009
    Messages:
    2,879
    Likes Received:
    1,277
    I have about 50,000 posts on a Wordpress blog of mine, hosted on a Dedicated server, along with 10 other Wordpress blogs, all with thousands of posts each, heaps of plugins, etc., and it costs about $400USD/month for the server. No lag, awesome speeds, the only problem I have is when I post too many posts consecutively, the site hangs for a minute. It clears up, but you have to learn to use Mass Posters instead. The site receives around 20,000+ unique views/day, and the others all around 1,000-3,000 max, and I have no problems at all.
     
  19. afallison

    afallison Regular Member

    Joined:
    May 8, 2009
    Messages:
    329
    Likes Received:
    143
    Occupation:
    Internet Marketer ;)
    Location:
    the woods
    are you saying 1 million at the same time? are you transferring a site? if not, i don't see the strategy in that at all. once google saw it, theyll prob sandbox you...
     
  20. TurkeySub

    TurkeySub Jr. VIP Jr. VIP Premium Member

    Joined:
    Jul 20, 2010
    Messages:
    174
    Likes Received:
    22
    I would suggest starting with a dedicated server, a nice cheap one. That way you can monitor your usage and make a judgment call to see if the project will make the cash to cover itself once your traffic picks up.


    • If you are good to host in the US, stop by CORENETWORKS - Get one of those and get your wordpress site online.

      (Yes, I have used the extensively, they have perfect uptime and you can't argue with the price, only downside they are in Michigan and not directly on the backbone. In short, the network is slightly slower.)
    • Then pickup W3 Total cache plugin (it makes supercache look as if it was developed in the dark ages)
    • Once that plugin is installed, either setup a poor mans CDN on your dedicated server (good place to start) and then when traffic picks up get a real CDN (MAXCDN - nice and cheap, very reliable).

      The CDN will then do most of the work on the site as it will be serving up your cache, java, images etc taking a major load off apache (apache will be your downfall, memory hog like none-other, but only real choice for wordpress).
    • Once that is done, setup the rest of the minify settings and caching in W3 and get to work importing your content.

    As your load grows, get a bigger server from them, then bigger and then buy one machine for MySQL and leave your apache run on the other, should be fine.