[thesite] how many ratings to appear in sidebar?

[.jeff]

martin,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Martin
>
> > i like that idea as well though that calculation will
> > be much more difficult to perform.
>
> Somewhere I've got a method for working out which data
> items are outliers to a normal distribution.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

be glad to take a look at it when/if you find it.

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> If calculation happened at the time of adding a new
> rating rather than on display, then the effort involved
> would be less I think.  (does it happen that way now?)
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

the calculation currently happens at the time the new rating is inserted,
therefore occurring only once and not for every page view that displays
ratings/averages (that's the only smart way).  the only thing is now, the
rating is done via a simple aggregate function, whereas doing something more
complicated will require some coldfusion logic and two trips to the
database.

just some thoughts,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/