Improve WordPress Database Performance

by Pinyo on April 3, 2009

I was browsing Greatnexus Internet and Web page and came across Yoast’s Optimizing WordPress Database Performance article. This article caught my interest because I have been having issue with my VPS crashing more often than it should and was trying to figure out what’s wrong.

In the article Yoast, mentioned a new Wordpress plugin called Debug Queries and said that it’s design to help you find inefficient database queries — naturally, I was interested. I downloaded the plugin and installed it on my main blog. The result was very surprising. Debug Queries found that my home page was making 1,776 database queries per page load — yes, almost 2,000! Upon further inspection, I found the offending plugin to be Cross-Linker. After deactivation of Cross-Linker, the number of database queries dropped to 21.

This is unfortunate because I like the plugin. But fortunately, I found another linking plugin called KB Linker that works just as well, and impressively, the number of queries remained at 21.

So I just want to shout out to Joost de Valk, Frank Bültge, and Adam R. Brown.  Good job guys. Thank you for terrific blogs and plugins.

{ Comments on this entry are closed }

Last time I wrote about using Google Analytics to boost your AdSense earnings, this time I am going to show you a simple process where you can use Google Analytics Advanced Segments feature to methodically improve your search engines ranking.

How To Find Web Pages With The Most Search Traffic

First let’s find your top performing web pages with the most search engines traffic. Here’s how you’ll find that information from your Google Analytics account:

  • Click on Content
  • Click on Top Content
  • On the upper right, click Segment

advanced-segements

  • Uncheck All Visits and select Search Traffic
  • Click Apply

You’ll see a screen similar to the one below — note that I filtered mine for privacy reason. Note that you now know your top performing web pages in term of search traffic, and can expand the list to see more results.

top-content

How To Find Top Performing Keywords For Your Web Page

Take note of these top search traffic articles and follow these steps to find top performing keywords:

  • Click on the URL link under the “Page” column
  • In the Analyze pull down, select Entrance Keywords
  • In the Content pull down, search for and select your chosen article

You’ll see a screen similar to the one below that shows all of the keywords for that particular article with all the vital statistics.

top-keywords

How To Improve Search Traffic With Google Analytics Advanced Segment Data

This is a very powerful piece of information that you are looking at, and there are several things you could do to leverage it. Here are a few ideas you can use to improve your search engines ranking using the data provided.

1. Keywords Optimization

You can start by rewriting the article to emphasize these top keywords.  Make sure they appear in important places like the title, first paragraph, meta description, headings, etc. You also want them to appear a few times in your content so that you can achieve a 3-5% keywords density.

If you want to rank well for a particular key phrase, then make sure you optimize the key phrase verbatim as per the suggestion above. For example, if I want to rank well for “new frugal ideas”, then I should have that exact phrase “new frugal ideas” appears a few times and in the headings, first paragraph, etc.

2. Link To This Article From Other Articles Using Various Keywords

Another approach is to link to this article using the keywords you’d like to improve from existing articles within your site, or better yet, from other web sites. Of course, the former is easier, but the latter is much more powerful.

3. Write Follow Up Article

Another idea is to write a brand new article that target similar keywords — i.e., an update to the original article, or a different look at the same idea, etc. In this new article, you also want to link back to the original article using the most important keywords as the anchor text. However, limit the number of links to 1-2.

If you’re lucky enough, you may even get the valuable indented search listing.

Conclusion

These are just a few examples of how you can optimize your web page, and there are other optimization ideas that you can apply to leverage the information made available by Google Analytics Advanced Segments.

Another nice touch about Analytics is the ability to change your timeframe on the fly so that you can see if what you’re doing is actually helping or hurting your site search ranking. However, try to keep your timeframe long enough so that you’re not fooled by daily fluctuation.

{ Comments on this entry are closed }

Leveraging your Blog with Paid Content

February 1, 2009

Most personal finance bloggers make money from their sites through advertising. The current next big thing in making money online is to develop paid content and/or consulting income. For personal finance bloggers like me, paid consulting about personal finance is almost impossible. There is already an industry that consults on finance issues — financial planners [...]

Read the full article →

Remove Dead Links From Your Blog To Improve User Experience

January 31, 2009

After blogging for a while, you will notice two inevitable trends.  One, other bloggers that you used to link to, or leave comment on your blog with links to their site stop blogging.  And two, some of your advertisers — specifically affiliate advertisers — stop running their program.  In both cases, when your visitors follow [...]

Read the full article →

4 Approaches to Making Money from Blogging

January 12, 2009

So, you’ve heard that people can make money from blogging, but you’re wondering “how exactly does that work, and what approach would suit your blog?”.
Text Links
You have a website which has outgoing links, other websites want to rank with search engines, and one of the main measures for page rank is the number and quality [...]

Read the full article →

Earn More Money With AdSense-Analytics Integration

December 24, 2008

Recently Google made AdSense-Analytics integration available for my account.  I only have a few days worth of data, but I am very impressed with the information so far. As I analyze the data, I am beginning to see some potential uses. If you have no idea what I am talking about, you should start [...]

Read the full article →

Simple Way to Add AdSense for Feeds to Your FeedBurner Feed

November 6, 2008

If you’re like me, you probably have FeedBurner feed all set up for your blog, but want to add AdSense for Feeds for some extra revenue.  And if you have done some research, you probably heard nightmare stories from people who switched entirely from FeedBurner feed to Google feed.  Lucky for you, I have a [...]

Read the full article →

Are Paid Reviews Unethical?

October 10, 2008

The ethical nature of paid reviews is a debatable one.  There are some bloggers that embrace paid reviews as a strategy to monetize their blogs.  There are some that steer clear of paid reviews citing that it would diminish their reputation and damage readers’ trust.  If you asked me a year ago, I would tell [...]

Read the full article →

Say Goodbye to WordPress Comment Spam with YAWASP

September 22, 2008

In How To Fight WordPress Comment and Trackback Spams, I shared several techniques that you could use to reduce the amount of comment and trackback spams that hit your blog.  Spams are not getting through on my blogs, but it’s still a pain to review for false positives among spams caught by Akismet. Fortunately, there’s [...]

Read the full article →

What’s Your Blog Exit Strategy?

September 17, 2008

Okay, you have launched your blog, and you have been pouring your heart and soul into it.  You are gaining readers, made new friends, and enjoying the overall experience.  Since nobody can blog forever, have you ever thought about what you’ll do down the road?  I haven’t thought about this until a friend (DebtKid) asked [...]

Read the full article →