Subscribe via Feedburner Flickr Images Youtube Profile LinkedIn Profile
CoolHandle

Benchmark #2: Blog

Thumbnail for Benchmark #2: Blog

This second part will analyze GD Star Rating impact on blog pages. This post will focus on number of queries that GD Star Rating adds to a page. There are many factors that must be taken into account, but I will cover most interesting cases of use.

The part of this test was memory use and generated page size, and that part of the test I will skip here, because results are covered in the post on Dev4Press, so go there are read on general blog performance. As for this most important test, I used default WordPress theme, and I first measured use of standard ratings, and than multi ratings. Also, since the number of queries for the plugin doesn’t depend on WordPress version, I will use WP 2.8 for the tests.

As for the improvements introduced with 1.5.0, I strongly suggest updating to 1.5.x because CSS and JavaScript will be loaded much faster due to optimization and compression that reduced size of these files by almost 90%. So that is no longer a factor in the use of this plugin, your page loading time and rendering are not going to be affected if you decided to use GD Star Rating.

gdsrbench total 300x157 Benchmark #2: Blog

Total number of SQL queries

Also, 1.5.1 introduced massive SQL queries optimizations that will be explained in the tests done bellow. One thing I didn’t measured is using GD Star Rating widgets, because each widget instance requires 1 (or 2 if you use trends) query to be executed, so there is nothing to measure, that’s the constant value.

So, if you look at the first graph, you can see blue bars that are clean WP installation (WP 2.8) without GD Star Rating. Red one is with GD Star Rating 1.4.8, and green is 1.5.2. First set is front page with 10 posts, and no auto-insert from the plugin, and basically no ratings are visible at this point. But 1.4.8 adds 23 SQL queries, while 1.5.2 adds only 3. These 3 queries are IP checks to see if the IP from where the request is coming is blacklisted. This can be disabled.

gdsrbench gdsr 300x155 Benchmark #2: Blog

SQL queries generated by GDSR plugin

On the second set of bars we now have auto-insert active, and all 10 posts have standard ratings. 1.4.8 adds 69 queries and 1.5.2 adds only 8, that’s less then a query per post. If you disable IP check, 1.5.2 adds only 5 queries for 10 posts. Actually if you have 20 posts on front page, 1.4.8 will add some 144 queries, but 1.5.2 still adds only 8.

Single post with no comments and single page act very much the same, and 1.4.8 adds 11 and 10 queries, 1.5.2 adds one query less. Again, big difference is with post with comments. 1.4.8 adds 70 queries for 10 comments, 1.5.2 adds 15. And even if we have 50 comments on a post, 1.5.2 will still add only 15 queries and 1.4.8 will add close to 350 queries.

I also did some research into other ratings plugins, but there is only one plugin still relevant, and that’s Lester Chan’s WP Post Ratings. If you use it one the front page with 10 posts, this plugin will add 12 queries, and that is 4 queries more than GD Star Rating 1.5.2. Consider the fact that WP Post Ratings has only a fraction of features that GD Star Rating does, that can’t be customized beyond choosing the graphics, and that only works with posts and now no longer has advantage of small number of SQL queries needed, than it’s obvious that GD Star Rating now is definitely number 1 rating plugin for WordPress.

As you can see there is no doubt that 1.5.2 is much better, and that optimizations are clearly visible. I have tested only standard ratings for now, because with multi ratings things are more or less fixed, and each post that uses multi ratings will execute 3 queries to get all data needed. If you use integration into comments, each comments specific rating requires 2 queries. There will be more optimizations done in this part, and I will work to reduce some of the queries executed for multi ratings.

GD Star Rating
a WordPress rating system

Share this:

del.icio.us DiGG Google StumbleUpon Google Buzz Microsoft Live MiXX RSS PDF
Benchmark #2: Blog, 7.4 out of 10 based on 17 ratings

14 Responses to “Benchmark #2: Blog”

  1. Paul Milson | July 9, 2009 at 1:54 PM

    This plugin is awesome! I’ve just wanted to update some of my wordpress based affiliate sites with ratings and reviews and looked for a plugin. I read a lot of reviews about the “paid plugins” but all of them was sales pitches :) So I gave a try to GD Star Rating…

    It’s good to see that you improve it continuously. Keep up the good work ;)

    GD Star Rating
    a WordPress rating system
  2. Michael Caswell | July 10, 2009 at 6:54 AM

    I use your rating plugin on my website joysticktales.com and it’s fantastic!

    Is there a way to create a list of the top rated posts, and put that on a page?

    As you can see on my navbar, I have a ‘Best Tales’ link and i would like that to work similarly to the way this page does:

    engrish.com/most-popular/

    Thanks and all the best!

    GD Star Rating
    a WordPress rating system
    • MillaN | July 10, 2009 at 10:49 AM

      Yes, it’s similar to widgets and can be done using shortcode or function. Use builder panel or check out info files.

      GD Star Rating
      a WordPress rating system
  3. Sean | July 10, 2009 at 7:41 PM

    Has anyone had any issues using the Fresh News wordpress theme. My site freezes upon loading when the GD Star Rating plugin is activated.

    I assume it has something to do with the Java Script but I have no idea how to fix it.

    Any help would be greatly appreciated.

    GD Star Rating
    a WordPress rating system
    • MillaN | July 10, 2009 at 8:00 PM

      No issues can be caused by the theme. And I don’t exactly understand what the problem is. As you can see I use Fresh News here and I had no problems. If I can see the problem for myself on your blog I might be able to help you. Check out tutorials that describe potential problems. In 99% of the cases your problem is already covered in one of these tutorials.

      GD Star Rating
      a WordPress rating system
      • Sean | July 11, 2009 at 8:17 AM

        I have enabled the plugin… If you use IE (I am using version 6) the site will freeze upon loading for about 10 seconds and then resume loading. If I disable the plugin the site loads fine.

        GD Star Rating
        a WordPress rating system
        • Sean | July 11, 2009 at 8:20 AM

          When I load this site my broswer freezes also if I am using IE6…..

          GD Star Rating
          a WordPress rating system
          • MillaN | July 11, 2009 at 10:16 PM

            I tried your website with IE6, IE7 and IE8 and I found no problems or freezes.

            GD Star Rating
            a WordPress rating system
  4. Michael Caswell | July 11, 2009 at 12:28 AM

    LOOKS GREAT THANK YOU :D ! – http://www.joysticktales.com/best

    although, what is that ‘Review’ column and how do i get rid of it?

    and is there a way to use star graphics rather than text?

    GD Star Rating
    a WordPress rating system
    • MillaN | July 11, 2009 at 12:52 AM

      Everything is controlled by templates, so to change rendering, you need to make template that displays what you need.

      GD Star Rating
      a WordPress rating system
  5. Michael Caswell | July 11, 2009 at 1:23 AM

    thanks again! The template work like a charm, fantastic plug-in! :D

    GD Star Rating
    a WordPress rating system
  6. Jesse | July 17, 2009 at 1:40 AM

    I checked with ie 6 and had no problems with freezing.

    GD Star Rating
    a WordPress rating system

Trackbacks/Pingbacks

  1. Dev4Press » WP Benchmark: 2.8.1 - July 13, 2009

    [...] week I have published similar tests for WP 2.8 and my GD Star Rating plugin, and you can see in that post how much SQL queries will that plugin add to the blog. Tests are done to show the value of cache [...]

  2. 晓闻心雨 » 基准测试:WordPress 2.8.1 - August 1, 2009

    [...] week I have published similar tests for WP 2.8 and my GD Star Rating plugin, and you can see in that post how much SQL queries will that plugin add to the blog. Tests are done to show the value of cache [...]

Comments are closed.