[thesite] how many ratings to appear in sidebar?

.jeff jeff at members.evolt.org
Sat Jan 19 20:18:39 CST 2002


> 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

just some thoughts,


jeff at members.evolt.org

More information about the thesite mailing list