woothemes/woocommerce — Issue #105: Optimise star ratings
Author: mikejolley
Created: 2011-10-26 16:26:13+00:00
State: open
Labels: Code improvements

>Star ratings: The rating works fine, but I have noticed that you calculate the rating when displaying a product in the frontend. No big deal on a single product page, but displaying the rating of all products on the overview page will generate an additional 2 database queries for each product.

>On a page with 50 results this will generate 100 additional database queries. I would recommend to change the system so that once a user submits a rating it gets pre-calculated and stored in the postmeta table. Would save a lot of overhead when on an overview page with lots of products/product widgets.