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

wordpress for million of posts

Discussion in 'Blogging' started by adam omar, Oct 21, 2015.

  1. adam omar

    adam omar Junior Member

    Joined:
    Dec 28, 2008
    Messages:
    152
    Likes Received:
    66
    Occupation:
    S E O
    Location:
    Google
    I am building a big wordpress blog that will host more that 2 million posts, can wordpress handle so many posts?

    My website is a business directory, and posts may reach10 millions.!

    How can I handle this big site with wordpress, any ideas?

    I ask about: tips for handling more than 1G database, plugins that can handle large databases.

    My hosting is 4G ram VPS with 200M Uplink from serermania. and i can upgrade to dedicated hosting if needed

    Please advice me.

    thanks

    updates
    for anyone will read this topic,
    after searching hours and hours, I found that wordpress cannot handle million of posts , and poples who tried to make large sites with wordpress, thier sites failed and dropped due to large database requests and that needs very high performance hosting that will cost $$$ and still page load will be very high due to too many database requests , however with low weight CMS like proccesswire you can make million of posts in any regular VPS hosting.

    the main issuw with wp that it stored all fields in just one table (wp-posts)
    howver professional CMS store each field in separated table and that will low number of requests.

    but i found a great resource for optimizing wp speed
    http://code.tutsplus.com/tutorials/optimizing-wordpress-with-varnish-and-w3-total-cache--cms-21136
    hope that will be useful for peoples who read my topic.

    thanks BHW
     
    Last edited: Oct 22, 2015
  2. Sherbert Hoover

    Sherbert Hoover Jr. Executive VIP Jr. VIP

    Joined:
    Dec 26, 2010
    Messages:
    1,099
    Likes Received:
    9,204
    Occupation:
    ORM - Content - SEO - PBN
    Location:
    Anywhere but the UK
  3. iamth3man

    iamth3man Regular Member

    Joined:
    Nov 27, 2014
    Messages:
    347
    Likes Received:
    104
    Location:
    imronald.com
    mmmm yeah i guess wordpress can handle it,mmmm but something wrong with your spec ,did you typo?
     
  4. auraita

    auraita Regular Member

    Joined:
    Dec 30, 2013
    Messages:
    283
    Likes Received:
    280
    for sure you must have a powerful hosting, and i believe you will need to change some default settings of php and mysql.
    please update this thread when you find a solution , i would like to know as well.
     
  5. blogzandstuff

    blogzandstuff Elite Member

    Joined:
    Jan 1, 2015
    Messages:
    5,791
    Likes Received:
    2,682
    Occupation:
    blog creator
    Location:
    UK
    Wordpress can handle anything, but as others have said you may need to tweak and have large hosting space. Why are you aiming for so much?
     
  6. LoftPower

    LoftPower Elite Member

    Joined:
    Feb 23, 2015
    Messages:
    3,186
    Likes Received:
    407
    That seems like an awful lot to me. I am sure that wordpress can handle it, but like others have said, why so high?
     
  7. adam omar

    adam omar Junior Member

    Joined:
    Dec 28, 2008
    Messages:
    152
    Likes Received:
    66
    Occupation:
    S E O
    Location:
    Google
    about hosting, I can upgrade anytime if needed.
    I'm asking about handling more than 1G database, and lot of resources that will be requested by million of posts....wordpress can handle that or should I need another professional CMS that can handle that site?

    the site will be business directory for 10 million US businesses.
    thanks
     
  8. Pergonde

    Pergonde Junior Member

    Joined:
    Jan 7, 2015
    Messages:
    126
    Likes Received:
    29
    Occupation:
    IT Spec
    Location:
    EU
    Okay, not going to talk about the other directories...
    10M US business? I don't think handling it by one server in one database is enough.
    I would suggest to speak to your hoster about that. Research your competition.
     
    • Thanks Thanks x 1
  9. Conor

    Conor Elite Member

    Joined:
    Nov 7, 2012
    Messages:
    3,577
    Likes Received:
    5,954
    Gender:
    Male
    Location:
    South Africa
    Home Page:
    Wordpress is great, but I'd say you might be pushing it here. Even if you have a ton of resources, your load time will increase as the database gets bigger.

    I recently had to migrate a site with around 4000 woocommerce products. The database was almost 2gb in size and the site was already slow as hell.
     
    • Thanks Thanks x 1
  10. adam omar

    adam omar Junior Member

    Joined:
    Dec 28, 2008
    Messages:
    152
    Likes Received:
    66
    Occupation:
    S E O
    Location:
    Google
    I love this solution, so how to devide database to small segments? and connect them to only one wp panel?
     
  11. kivkiv

    kivkiv Registered Member

    Joined:
    Oct 22, 2015
    Messages:
    89
    Likes Received:
    2
    2millions posts in a blog, wow :cool:
     
  12. adam omar

    adam omar Junior Member

    Joined:
    Dec 28, 2008
    Messages:
    152
    Likes Received:
    66
    Occupation:
    S E O
    Location:
    Google
    Guys I found a great CMS that is very suitable for my project , just for anyone who like my case
    https://www.youtube.com/watch?v=Wl4XiYadV_k

    Proccesswire GREAAAAAAAAAT AND EAAAAAAAAAASY SOLUTION FOR CMS AND ANY PROFESSIONAL DIRECTORIES