View RSS Feed

The ExcelGuru (Ken Puls) Blog

Site Performance

Rate this Entry
Over the past few months, I've been getting an ever increasing number of emails from my site with errors due to overloading. Fortunately my friend Simon is really good with websites, and is very helpful too, so I've been able to put in some changes that I hope will fix things.

I think it's fair to say that I'm pretty accomplished with Excel, but man... websites are a different matter. Every day I touch this stuff I realize how little I know. Granted, I'm learning all the time, but I've got a LONG way to go before web stuff is as straight forward as Excel to me!

The first thing that we focussed on was banning a great deal of web spiders from the site. For those who don't know, spiders are generally sent out be search engines to "crawl" the web, indexing the pages on websites. This is how Google, Bing, Yahoo and others know which pages to serve up to you during a search. We also see spiders from Facebook, Feedburner (RSS feeds) and other sources. I was always under the impression that spiders were good for websites, but this isn't always the case. Some spiders just cause traffic without any real benefit, and others, while good, are good for a market that you don't serve. Spiders trolling my site and indexing it for an audience that doesn't speak or read English, for example, don't serve me much good. They cause a significant load with very little benefit since none of my content is in their market's native language.

Something else that has been happening here is that I've been experiencing a massive amount of spam registrations. While I do have tools that block registrations for known spammers, I've still had way too many slip the net and post on the site. Granted you may have only seen the one or two that made it through the automatic moderation, but I've been wiping out tons of them behind the scenes.

Now interestingly enough, as I was working through the process of blocking spiders, I also discovered that I'm getting a large amounts of hits from one specific country on a daily basis. And further investigation helped me to the realization that 100% of spam posts are coming from within their borders.

After a lot of investigation, evaulation of spam prevention methods and soul searching, I have made the difficult decision to ban any traffic originating their country to my website. It was not an easy decision to make, believe me. As an MVP, my philosophy is to help people work with technology, no matter their race, skin color or religious beliefs. What unites us is our need to get things done, and I like helping people with Excel. Implementing a country wide block is sure to affect a legitimate user at some point.

At the end of the day, however, I also have to realize that time spent moderating spam and dealing with performance issues to serve a country that has such a small percentage of English speaking natives is counter productive. The reality is that very few people there will be affected, at the cost of everyone else who does actually use my site for it's intended purpose.

While I haven't successfully been able to ban all IP's from their country yet, (the site I used to source my list claims 99.5% accuracy,) I did ban all their know IP ranges a few hours ago. (So if you're reading this, then I'd say your country wasn't the one I've blocked!)

Time well tell how effective this is in the long run, but one thing I can see is that the site performance has already improved drastically.

Submit "Site Performance" to Digg Submit "Site Performance" to Submit "Site Performance" to StumbleUpon Submit "Site Performance" to Google Submit "Site Performance" to Twitter Submit "Site Performance" to Facebook Submit "Site Performance" to LinkedIn

Site Stuff


  1. JP2112's Avatar
    IP banning is only partially effective. Since you run WordPress, you should consider using a plugin like Bad Behavior. There is also an adaptation of this plugin for vBulletin. It blocks known bad IPs, comment spammers, bots, SQL injections, and more.
  2. Ken Puls's Avatar
    Hi Jimmy,

    Agreed. I already run StopForumSpam, which blocks known bad IP's, usernames and email addresses from registering. But I was still getting overrun. It's a constant war keeping up. So this is just one more layer on top is all.
  3. nadyvaxaw's Avatar
    Google it.