WP-ShortStat Slowing Down Root Index Pages
Published Tuesday, July 17, 2007 @ 8:27 am • 4 Responses
[ Keywords: wp-shortstat, shortstat, wordpress, plugin, slow, country, ip, lookup, root, index, fix ]
For over a year now, I have been using Markus Kämmerer’s (Happy Arts Blog) WP-ShortStat plugin for WordPress. The plugin is relatively well-maintained and remains one of my favorite admin tools. Great for popping in on stats without logging into Mint. Nonetheless, due to its IP/country-detection functionality, WP-ShortStat has experienced its share of difficulties (e.g., read through the change log on the plugin’s home page). In this article, I describe how WP-Shortstat slows down the root index-page of a site, and then suggest a (temporary) fix for the issue.
The Issue
I have heard of several different WP-ShortStat problems resulting from the country-lookup feature, including missing statistics, broken pages, and pages not loading (due to slowness of lookup server, etc.). Too many problems for something I really never look at anyway. The new (for me, anyway) issue with WP-ShortStat involves an extremely slow (or even non-loading) root index-page of any site running WordPress installed in a subdirectory. I experienced this problem under the following conditions at the exact same time and on three different blogs:
- WordPress installed in a subdirectory (not root)
- Running Markus Kämmerer’s WP-ShortStat plugin (version 1.7h)
The problem is that, all of sudden, and for no apparent reason (i.e., no changes had been made), the index.php files located in the root directory (i.e., outside of the WordPress installation directory) stopped loading. Well, okay, they would load, if you let them spin for long enough (average load time: ~3.33 minutes!), which is the same as not loading at all given the average visitor’s attention span. The bizarre thing is that every other page on the sites loaded normally (ha!). Indeed, all pages within the blog itself continued to load quick, fast, and in a hurry, but for some reason, the root index.php page would not. Here is a summary of the symptoms:
- Suddenly, the site’s root index.php page will not load (or will load very slowly)
- Meanwhile, all other site pages continue to load normally and without problems
The Solution
Granted, most of my traffic is routed directly to internal pages (thankfully, only a fraction of total views are for the root page), so it is doubtful that many visitors noticed the problem before I could solve the issue. At first, I had NO idea why the root page — and ONLY the root page — would not load. Total stumper. Eventually, after a few rounds of the plugin-elimination game, the culprit was revealed! Disabling the WP-ShortStat plugin completely resolved the issue.
And that was just fine as a temporary fix, but I wanted to continue using the WP-ShortStat plugin — I just wasn’t ready to say goodbye (sniff). So, after some research1, trial and error, it became clear that the offending aspect of the plugin involved that incredibly uninteresting IP/country-lookup feature. Nice — I never used it anyway!
Thus, I decided to hack the plugin, solve the problem, and keep WP-ShortStat running tuf. Fortunately, the fix is a snap. Crack open the plugin file, scroll down to around line #21, and locate the following:
function determineCountry($ip) {
$coinfo = @file('http://whois.happyarts.net/ip2country.php?ip=' . $ip);
$country = trim($coinfo[0]);
if($country == '(Private Address) (XX)'
|| $country == '(Unknown Country?) (XX)'
|| $country == ''
|| !$country
)return 'Indeterminable';
return $country;
}Now, simply comment out the first two variable declarations, $coinfo and $country like so:
function determineCountry($ip) {
// $coinfo = @file('http://whois.happyarts.net/ip2country.php?ip=' . $ip);
// $country = trim($coinfo[0]);
if($country == '(Private Address) (XX)'
|| $country == '(Unknown Country?) (XX)'
|| $country == ''
|| !$country
)return 'Indeterminable';
return $country;
}..and that should do it. Upload, test, and enjoy. If you were experiencing the issue described above — or any similar issue (pages not loading, slow server response, etc.) — this fix should definitely solve the problem. Sure, you won’t enjoy those nifty country IP lookup data, but you will eliminate all third-party server issues and other related problems.
If this hack worked for you, I would love to hear about it. Or, if you have encountered similar problems, or found a different solution to this or a related issue, please leave a comment and share your wisdom!
References
About this article
Related articles
- WordPress Tip: Reduce the Size of the WP-ShortStat Database Table
- Redirecting Subdirectories to the Root Directory via HTAccess
- Delete index.dat on Windows 98SE
- Conditionally Load WordPress Pages
- Stop WordPress from Leaking PageRank to Admin Pages
- Seven Ways to Beef Up Your Best Pages for the Next Google PR Update
- htaccess Combo Pack: WordPress Permalinks and non-www Redirect
Dialogue
4 Responses Jump to comment form
July 30, 2007 at 11:13 am
First lookup maybe? Cached afterwards with teh object cache?
Share your thoughts..
← Previous post • Next post →
« Allow Google Reader to Access Hotlink-Protected Images • Wrapping Your Head around Downlevel Conditional Comments »
1 • Markus Kaemmerer
July 25, 2007 at 12:07 am
You should have updated to a newer version of WP-ShortStat. This had fixed the problem,too. The old version you are using (before 6. December 06) we used an HTTP based country detection service. This was slowing down our webserver to much. We switched of this service for months now (you can read it on http://blog.happyarts.de/wp-shortstat) and use UDP now. This is much faster for all users and our server can handle hundres of pings per second without problems.