Tilted Forum Project Discussion Community - View Single Post - How much horsepower am I gonna need to run this site?

sailor · 07-12-2004, 04:34 PM

OK, so as some of you who have been paying attention may have noticed, I am in the midst of getting an e-commerce site up and running for a friend. The site is essentially working, but now I am embroiled in the search for a host. He expects the site to be serving approximately 500-1000 "views" a day (a view is visiting the frontpage and then viewing a long article that is prepared daily), with peaks of 2000-4000. The site is written with PHP and uses mySQL to store all of the data. Most of these hits will be in the morning. There are other queries being run as well--users logging in, a news section, etc.

I can easily find a host that will accomodate the space and bandwidth needs, but the question I have is one of processor usage: how much is that mySQL usage gonna hit the host? I dont want to wake up one morning to find the account suspended because we were killing the rest of the server while mySQL fetched thousands of articles for people. Ive never had to deal with this problem before--everything else I have written has gone on my own personal server and doesnt get that many hits.

I know that ideally we would have a dedicated server, but until things are up and running, he doesnt want to commit upwards of $100 a month for hosting, and I dont blame him.

Suggestions? How much hurt is this thing gonna put on a box? Am I going to have to get a dedicated box anyways? Any suggestions for a host?

07-12-2004, 04:34 PM	#1 (permalink)
sailor beauty in the breakdown Location: Chapel Hill, NC	How much horsepower am I gonna need to run this site? OK, so as some of you who have been paying attention may have noticed, I am in the midst of getting an e-commerce site up and running for a friend. The site is essentially working, but now I am embroiled in the search for a host. He expects the site to be serving approximately 500-1000 "views" a day (a view is visiting the frontpage and then viewing a long article that is prepared daily), with peaks of 2000-4000. The site is written with PHP and uses mySQL to store all of the data. Most of these hits will be in the morning. There are other queries being run as well--users logging in, a news section, etc. I can easily find a host that will accomodate the space and bandwidth needs, but the question I have is one of processor usage: how much is that mySQL usage gonna hit the host? I dont want to wake up one morning to find the account suspended because we were killing the rest of the server while mySQL fetched thousands of articles for people. Ive never had to deal with this problem before--everything else I have written has gone on my own personal server and doesnt get that many hits. I know that ideally we would have a dedicated server, but until things are up and running, he doesnt want to commit upwards of $100 a month for hosting, and I dont blame him. Suggestions? How much hurt is this thing gonna put on a box? Am I going to have to get a dedicated box anyways? Any suggestions for a host? __________________ "Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws." --Plato