Home : Products : Gossamer Links : Discussions :

## the value of rating

I have not really looked at the way it works but I have seen a rating of 4.83 today. I think all rates are multiplied with the number of rates, e.g. one new rating is added (1) and the total is divided with the number of ratings+1. If the ratings are updated very often it might happen that for a thounsand times users rate a link with 1 and every rate is updated instantly. So we have

(4.83 * x + 1) / (x + 1) = 4.825 ( I guess 4.825 will remain 4.83)

which results in x = 765

I donīt know if this is how LinsSQL behaves and I donīt see a problem, just think it is intersting that in this case a thousands of ratings of 1 have no results on 765 ratings.

Regards

Niko
Sorry - having just written out that explanation - I now see what your point is!

I think the only way round this is to increase the decimal places on the rating field.

#### Last edited by:

afinlr: Oct 29, 2003, 11:55 AM
Too fast - I was thinking while typing. Sorry.
... so at least you were thinking.

Not everybody knows how to do that nowadays.