Need Help Choosing Server Type

7 replies
  • WEB DESIGN
  • |
Hello Everyone,

First of all let me say that I am new to WF or any forums for that matter. I am also very excited to be surrounded by such knowledgeable people! I currently own a steel erecting company in Cincinnati and in April of 2010 I became the owner of a website. Going from the steel business to trying to get a website off the ground and get it monetized has been an adventure and been the cause of very little sleep at night! I love the fact that this is something completely different from what I have ever done in business and I am constantly learning. With that being said if there is anyone out there who is willing to coach/guide a young entrepreneur in the ways of operating a successful internet business any and all help would be greatly appreciated! I guarantee that you will not find someone more motivated and willing to learn than myself!

On to my question.....My website has a database of listings i.e... names,addresses,city,state,zip, and phone numbers. Our site currently has around 96,000 entries and growing. We have a search on our site that filters through searchable keywords to find entries that match the search criteria and then using googlemaps produces results based on keyword relation as well as distance from the zip code entered. As I said I am new to all of this so i would guess that there is quite a bit of activity going on with each search preformed. This has slowed the site WAY down and getting slower as we continue to add entries. My designer is currently hosting this site on his shared server. What are the most effective/least expensive server options suitable for my site? What companies would be recommended?This site could have over a million searchable listing within the year.

Thank you very much for any and all help

Josh
#choosing #server #type
  • Profile picture of the author xtrapunch
    Get a VPS (virtual private server).

    With that being said if there is anyone out there who is willing to coach/guide a young entrepreneur in the ways of operating a successful internet business any and all help would be greatly appreciated! I guarantee that you will not find someone more motivated and willing to learn than myself!
    Sorry for my language, but why the hell will anyone want to waste his time mentoring you when there's nothing in store for him. I guess you need to modify your offer.
    Signature
    >> Web Design, Wordpress & SEO - XtraPunch.com <<
    Web Design & SEO Agency | Serving World Wide from New Delhi, India

    {{ DiscussionBoard.errors[3538515].message }}
    • Profile picture of the author goin4it
      Originally Posted by xtrapunch View Post

      Get a VPS (virtual private server).


      Sorry for my language, but why the hell will anyone want to waste his time mentoring you when there's nothing in store for him. I guess you need to modify your offer.


      It wasn't an offer.... let's just say I wouldn't turn down some advice if someone wanted to take a look at my site and give me a few pointers...that's all. Didnt really make sense did it? Thanks on the VPS info.
      {{ DiscussionBoard.errors[3538666].message }}
  • Profile picture of the author Shirlyn
    A VPS server hosting would run best for you and you will get good security and reliability in hosting.
    Signature
    {{ DiscussionBoard.errors[3540391].message }}
    • Profile picture of the author goin4it
      Thank you Shirlyn for your professional response!
      {{ DiscussionBoard.errors[3569331].message }}
  • Profile picture of the author ronc0011
    I would recommend moving the site to somewhere like Hostgator. The big companies are going to have the server capacity and bandwidth to handle the kind of traffic you are talking about. Also their systems are already configured for security concerns. In other words there a host of things involved in web servers that you really don't want to have to deal with yourself because they are full time jobs in and of themselves.
    {{ DiscussionBoard.errors[3569365].message }}
  • Profile picture of the author SteveJohnson
    First, welcome to the WF.

    96K entries is nothing, and shouldn't, by itself, be causing your site to slow down. What WILL cause a slowdown with that number of rows are poorly designed tables and queries. The tables need to be indexed properly, and queries structured to use as little memory and resources as possible. It also would probably help to implement query caching if you haven't already.

    EDIT: I suppose I shouldn't say 'poorly designed', rather, 'inefficiently designed'. What would work perfectly fine for a db with a thousand or two entries could very well run into problems when scaled up. But that's not something your average web designer person would know what to do with. I'm by no stretch an expert either, so don't take this as advertising for work
    Signature

    The 2nd Amendment, 1789 - The Original Homeland Security.

    Gun control means never having to say, "I missed you."

    {{ DiscussionBoard.errors[3569549].message }}
    • Profile picture of the author goin4it
      Originally Posted by SteveJohnson View Post

      First, welcome to the WF.

      96K entries is nothing, and shouldn't, by itself, be causing your site to slow down. What WILL cause a slowdown with that number of rows are poorly designed tables and queries. The tables need to be indexed properly, and queries structured to use as little memory and resources as possible. It also would probably help to implement query caching if you haven't already.

      EDIT: I suppose I shouldn't say 'poorly designed', rather, 'inefficiently designed'. What would work perfectly fine for a db with a thousand or two entries could very well run into problems when scaled up. But that's not something your average web designer person would know what to do with. I'm by no stretch an expert either, so don't take this as advertising for work
      Thought I was going to have an easy night...........but thanks to you I will be up researching what exactly you are talking about! My nights keep getting shorter and shorter..lol! Thank you for the good info Steve!
      {{ DiscussionBoard.errors[3571254].message }}

Trending Topics