1. This website uses cookies to improve service and provide a tailored user experience. By using this site, you agree to this use. See our Cookie Policy.
    Dismiss Notice
  2. The hosting section is sponsored by Hostwinds visit the BHW Partnership program for your exclusive BHW member hosting benefit today.
    MUST be signed into your BHW account.
    Dismiss Notice

Hosting for a WordPress site with 2 million + post

Discussion in 'Web Hosting' started by banda065, May 18, 2020.

  1. banda065

    banda065 Regular Member

    Joined:
    Dec 27, 2013
    Messages:
    223
    Likes Received:
    32
    Hi,
    I am trying to import 1 million post to my wordpress site using WP ALL IMPORTER -FREE
    current batch is 1 million there may be many more posts later.
    but when i import about 75000 posts to my site the import priocess got very slow. Currently i am usng shared hosting on namecheap. seems i can't host my site there. may be i need VPS.
    Can some one recommend me the ideal hosting plan for my wordpress website with 2 mn +posts
    I have a poor budget
     
  2. ContentExpert

    ContentExpert Jr. VIP Jr. VIP

    Joined:
    Jan 16, 2017
    Messages:
    2,239
    Likes Received:
    3,003
    Occupation:
    Your Content Writer
    Location:
    Orlando, FL.
    Home Page:
    Well, it's not ideal for a "poor budget" but WPX would be best.
     
    • Thanks Thanks x 1
  3. Rawr420

    Rawr420 Registered Member

    Joined:
    Apr 27, 2020
    Messages:
    65
    Likes Received:
    33
    Poor budget, a lot of posts. Did you even monetize that? How you can have a lot of posts and you don't earn money? You should look for that. Because having 1 website with many posts and it doesn't generate revenue, maybe is a good idea to discontinue it or sell.

    With low budget, you won't find a good solution for that. Maybe Kimsufi servers are cheap. If you can't afford the prices of Kimsufi, sorry to say. Maybe it's time to close or sell your website.

    @ContentExpert I think WPX is not the solution here, they don't allow excessive usage of CPU and MySQL Requests, if the website is bigger. It will hurt. Kimsufi is the best way IMO.
     
    • Thanks Thanks x 2
  4. hardgamers

    hardgamers Registered Member

    Joined:
    Aug 16, 2014
    Messages:
    64
    Likes Received:
    27
    Get a dedicated server on kimsufi, soyourstart or hetzner auction.. if you want to use vps make sure you buy vps with dedicated CPU,that will allowed you to use 100% CPU that you rent (don't use vps with shared CPU, you have a high chance getting suspended when you import so much post)... Also consider using server/vps with minimum of 4GB of RAM (16GB or more will be good) and use ssd drive if possible. you can try rent vps from buyvm, netcup, contabo or OVH just make sure you got dedicated cpu

    If you don't have budget then try to import in small batch if possible (like 10.000 post or less at once)..
     
    • Thanks Thanks x 1
  5. writehow

    writehow Regular Member

    Joined:
    Mar 3, 2014
    Messages:
    312
    Likes Received:
    58
    Location:
    What?Where?Who?
    If you consider 25$ for 10GB storage "the best"

    For that price you are getting 80GB SSD 2CPU 4GB RAM Vultr CLOUD!
     
    • Thanks Thanks x 2
  6. Festinger

    Festinger Jr. VIP Jr. VIP

    Joined:
    Feb 27, 2014
    Messages:
    8,835
    Likes Received:
    10,096
    Occupation:
    Download Premium WordPress Themes and Plugins @
    Home Page:
    Go with Closte.
     
  7. kaudo

    kaudo Newbie

    Joined:
    Jan 9, 2015
    Messages:
    32
    Likes Received:
    17
    Gender:
    Male
    Split the csv file in few smaller files.
     
    • Thanks Thanks x 2
  8. banda065

    banda065 Regular Member

    Joined:
    Dec 27, 2013
    Messages:
    223
    Likes Received:
    32
    Thank You all for your valuable comments as per your recomendation i tried to buy kimsufi and ended up buying at OVH
    now i have installed WordPress there

    i can't find the way to add domain and to add plugins to wordpress it ask ftp info. I could not find in the email (or anywhere)

    I have tried google and support tickets (both did not work) can someone please guide me to add

    01. domain
    02. find ftp info (to add plugins to WordPress)
     
  9. Repulsor

    Repulsor Senior Member

    Joined:
    Jun 11, 2013
    Messages:
    867
    Likes Received:
    308
    Why didnt you split the import file into parts? That was the first thing to do I guess.
     
  10. Gogol

    Gogol Jr. VIP Jr. VIP

    Joined:
    Sep 10, 2010
    Messages:
    6,368
    Likes Received:
    6,532
    Gender:
    Male
    Occupation:
    Programmer
    Location:
    Pale Blue Dot
    Lol. Probably the funniest thing I have read today.

    No, shared hosting is not going to work. Oh, and you need cheap.. right? It's not gonna happen.

    You will need a scalable infrastructure. Just think, what will happen if you get one visitor per post parallelly? You will see smoke, lol.


    As for importing, you will either need to import batch by batch (there are some sql scripts which let you do this.. google it), or you will need to do it from ssh. Everything else will probably timeout/be unreliable.
     
  11. hardgamers

    hardgamers Registered Member

    Joined:
    Aug 16, 2014
    Messages:
    64
    Likes Received:
    27
    what kind of service that you bought from OVH ? cloud, vps, dedicated server or webhosting ? if you buy webhosting, i don't think it will be good enough for your purpose unless you split that posts into several batches ....
     
  12. FatBee

    FatBee Jr. VIP Jr. VIP

    Joined:
    Apr 4, 2015
    Messages:
    1,794
    Likes Received:
    1,173
    Gender:
    Male
    Occupation:
    ⬇️Free Wordpress Optimization⬇️
    Location:
    ⚠️Are you lazy? I can do it for $49.99⚠️
    Home Page:
    He can go cheap on a VPS. But since that idea didnt spark for him he is clueless how to set it up
     
    • Thanks Thanks x 1
  13. Misan Kumar

    Misan Kumar Regular Member

    Joined:
    Feb 4, 2020
    Messages:
    287
    Likes Received:
    72
    Gender:
    Male
    Location:
    MARS
    Home Page:
    if I were you I would go for cloud hosting like google and amazon cloud I think they are more powerful. if you want for cheap cloud hosting ResellerClub would be highly recommended.
     
  14. Gogol

    Gogol Jr. VIP Jr. VIP

    Joined:
    Sep 10, 2010
    Messages:
    6,368
    Likes Received:
    6,532
    Gender:
    Male
    Occupation:
    Programmer
    Location:
    Pale Blue Dot
    Ultimately, he will need to scale it up somehow. If his site receives no traffic, it should be okay. The problem will start when he starts getting traffic. Also "cheap" is a vague term. He needs to specify the budget. It's not gonna be $10/yr for sure lol.
     
  15. FatBee

    FatBee Jr. VIP Jr. VIP

    Joined:
    Apr 4, 2015
    Messages:
    1,794
    Likes Received:
    1,173
    Gender:
    Male
    Occupation:
    ⬇️Free Wordpress Optimization⬇️
    Location:
    ⚠️Are you lazy? I can do it for $49.99⚠️
    Home Page:
    in his case ill consider CHEAP around 10-20$ per month for a VPS

    Example:

    RAM 12288 MB
    CPU 4 x 3 GHz vCPUs
    SSD 60 GB
    BANDWIDTH 150 Mbps
    TRAFFIC Unlimited
    9.99 € mo.
     
    • Thanks Thanks x 1