resellerspanel hosting

[MikeHolohan]

Anyone ever heard of http://www.resellerspanel.com/

any info appreciated...

Mike.

[snakes1100]

nvr heard of it.

[MikeHolohan]

I am in live chat with them and they told me currently, the limit for MySQL queries is 45,000 queries per hour

can anyone advise me on this as I have no idea what that means...

Mike.

[snakes1100]

Thats how many queries can be called in mysql per hour, if your forum home page has 11 queries, forumdisplay has 13 queries, showthread has 13 queries and you have 200 users online, that limit might not take long to reach.

If you have stats tracking like awstats or something, you can get your page views number for the busiest hour and count up what your using per hr on a rough guess.

[MikeHolohan]

Thanks very much snakes, that helps a lot, as my forum grows I will grow my hosting with it but that should be quite enough for now...

Mike.

--------------- Added 1206819874 at 1206819874 ---------------

hour 11 pages 7204 hits 45736 bandwidth 313.46 MB


This appears to be my busiest hour but I would imagine most of the hits are from bots as I have only 200 members total (and growing)

Mike.

[snakes1100]

Your welcome, those stats come in handy for somethings on occasion... :D

That can give you a rough estimate though, awstats also lists the actual page/file that was called as well, so you can look and see what files are being hit/used the most.

[MikeHolohan]

Thanks for all your help snakes... Mike.

[Marco van Herwaarden]

hour 11 pages 7204 hits 45736 bandwidth 313.46 MB

Let's assume a low number of queries of 10 per page (reallity will be higher!!). 7.204 * 10 = 72.040

This is already much higher then the 45.000 limit.

PS Members/Guests/Bots makes no difference they all load pages and execute queries.

[MikeHolohan]

Ok thanks, is there a recommended hosting company by vbulletin?

[snakes1100]

I still dont think vbulletin recommends any one hosting company, its all word of mouth by members and everyone has their opinion of who they host with and their own experiences with those hosts, you could ask 10 ppl that host with hostgator, half of them might say they sook, the other half would disagree as to why and say they nvr had that issue.

[MikeHolohan]

Snakes thanks for all your replies, I am impressed that you would take the time to answer these posts...

Mike.

[snakes1100]

your welcome and good luck

[MikeHolohan]

I am fed up with 50 or 60 spiders on my site using all my sql queries,

at any time, day or night I have 50-60 spiders per hour...

is there a way to limit how many spiders are crawling all over my site...

[SEOvB]

Use a robots.txt to block all spiders from crawling your site. You won't get listed in the search engines but it'll stop your query usage. Or at the very least use a robots.txt to limit the crawl rates

But i'd suggest moving to a different host, such as ASmallOrange.com or PowerVPS if your site warrants a VPS.

[MikeHolohan]

My question really is why do the spiders need to crawl it so often, of course we all want to be found in the search engines but really 50-60 spiders every hour is a bit strange, is it normal, am I have less or more than others?

I have a small non profit site that I am trying to grow and I don't want all my sql queries being used by spiders and yet I still want to be found by the search engines, i would love a vps but couldn't afford to sustain one... I have reseller hosting with Hostgator...

[SEOvB]

Google will usually only send one spider thats really efficent, its probably that pesky yahoo bot which is killing you.

Use robots.txt to slow the spiders, you can see what should be in a standard vBulletin robots.txt (http://seovb.com/vbulletin-robotstxt-11/index.html) and where to put it on your server, and then just adding something like


User-agent: *
Crawl-delay: 120


to the end of it will slow the bots. These changes probably won't take effect for 24hrs, as most spiders only download robots.txt file once a day.

[MikeHolohan]

Wow thanks for that...

is the crawl delay value in minutes like 120 minutes?

thanks again.. Mike.

--------------- Added 1207078601 at 1207078601 ---------------

worked a charm, I have only 8 spiders on my site now... thanks for the tip...

[edgecutioner]

Ok thanks, is there a recommended hosting company by vbulletin?

Well no.

Can Jelsoft run a hosting company for vB just like IPB does? I mean, that would be cool.....

[Hornstar]

Personally I would much prefer a million spiders and spend a bit more to be on a better server. Anyway to ensure all my content is being indexed at a faster speed in the hope to attract more members for the content that i'm trying to drive members to is important IMO.

As for a good host, there are many, it does not seem like your forums are that busy or large currently and you can still get away with shared hosting until you start to get quite a lot larger where you start using too many resources for that server/host where it would become unfair to the other people on the server.
Some hosts are good with their tos in this respect, others have things in place where you use x amount cpu you will be suspended and the value is not even that high sometimes.

I run a hosting company (wont release the site here) but I feel if a hosting company is ever suspending or terminating sites without giving adequate warning and advise before hand, then you should never go with that host.

Remember in most cases you are paying for what you get. In some cases you may find a golden treasure but for just how long will it last? Take a look at how long they have been around, look for reviews etc. WHT can be a good place to start looking for hosts as well.

I wish you luck in finding a good host :)