Hi All,

I'm not sure what to do...

I've been signed up as a reseller with two companies for a while. Both companies do well for what I've had so far, but I have one site www.reviewum.com that uses a bit more resources than I think either will put up with for too long.


If I have one site that uses quite a few resources, but a TON that are small scale sites what should I do? There are other resellers out there with much higher prices, but this doesn't mean that they will give me more resources.

I don't really want to go VPS or dedicated as I don't have a clue how to manage them, and I don't think my site is at the point that it needs that many resources.

Another option is to put my one account on a non-reseller host, but for all I know they may just be a reseller themselves.

Any suggestions?

Thanks in advance for the help!

Interesting site! But what do you mean when you say it's very resource-intensive? How many users do you have at peak times and how many db queries do they perform then? Maybe the best idea would be to approach your prospective hosts with this information and ask them if that much load is ok with them. Of course you're right that higher price doesn't necessarily mean more resources; much will depend on how many sites (and what kind of sites) they put on a server - if they balance it well, you could be ok. And don't think that just because your host puts you on a P4 your site will be faster. The key is server load.

Just my 2 cents...

GDO

HasGreatDane - Thanks for the reply!

Peak users are about 30, but it is rare.

I'm getting the site converted to PHP and MySQL so I'll find out soon enough how many DB queries I'm getting. (BTW, is there a script or any easy way in Cpanel / MyPHPAdmin to really determine the # of queries to a DB?)

So, this brings up another good question, besides disk space, bandwidth, DB queries, what are other metrics to use to determine "resource usage"?

Originally posted by reviewum.com
HasGreatDane - Thanks for the reply!

Peak users are about 30, but it is rare.

I'm getting the site converted to PHP and MySQL so I'll find out soon enough how many DB queries I'm getting. (BTW, is there a script or any easy way in Cpanel / MyPHPAdmin to really determine the # of queries to a DB?)

So, this brings up another good question, besides disk space, bandwidth, DB queries, what are other metrics to use to determine "resource usage"?

Converting it to PHP and MySQL sounds like an excellent idea, if you ask me. Last time I was hosted on a Windows machine was well over six years ago and I'm not planning to go back. To answer your questions: I don't think there's a way to see the number of queries in cpanel but most scripts display it when you run them. Or if you look at the code you can determine how many requests would be made by certain user actions. Disk space is not really an issue unless you have a site over 10 gigs which is extremely rare. I believe the most important metrics are data transfer (bandwidth) and db queries. If you rarely get 30 simultaneous users and your script is well-written, I don't suppose that a decent host should object to it, but I might be missing something (I don't have such resource-intensive sites). Let's wait to hear from the experts.

GDO

Thanks again!

I've heard some reseller hosts complain about "number of connections" to the DB. Is this just another way of saying number of queries / concurrent users?

Originally posted by reviewum.com
Thanks again!

I've heard some reseller hosts complain about "number of connections" to the DB. Is this just another way of saying number of queries / concurrent users?

Yes, that would be the number of queries, though not necessarily related to the number of concurrent users - if you have a poorly written board, for example, it could easily become a resource hog even with a couple of users. One more issue could be (someone correct me here if I'm wrong) the size of the database. If the script has to comb through a table with 10,000 items in it, it might be pretty CPU-intensive and less welcome.

GDO

Are you using Access as the database ? That's a major major bottleneck...it won't work well at all in a medium traffic site. Moving your db to MSSql or Mysqlwill bring instant perfomance benefits and reduction in resource usage.

MS Access is just not meant for a busy site....and MS recommends the same thing in many articles.

nipl - That's exactly why I'm doing the conversion to PHP and MySQL! Access was just meant to be for testing the site and working with it while it was small. Now that it is growing and since I have so much space on my reseller account I thought it was time to move / convert.

I guess the main concern was brought up because I got into trouble running PhpAdsNew on one of my shared / reseller accounts. I have the ads served from one domain and show the ads on reviewum.com. My host complained about resource usage with PhpAdsNew, so I got worried about the site itself.

Thanks for the repies!