« More about You | Main | Spotlighting »
April 28, 2006
Fun with sorting
I fixed a few bugs with relation to sorting.
The first isn't really a bug--sorting by rating now also sorts by the number of reviews a particular company has. I think this makes most sense. If there are more reviewers, there's a higher chance that the company had some people who had said good things about them.
However, this is still not an ideal way to rank companies. A better way would be to do some sort of weighting with the number of reviews and their scores. A standard deviation would also be able to tell whether a particular company has mixed reviews. If anyone has any suggestions on a better rating system, please contact us.
I also fixed a bug with the sorting by ratings while viewing companies that are associated with a particular tag, like photos, for example. After reading some good articles on database denormalization, I think I'm starting to grow as a database designer. In any case, the bug is patched!
Posted by jamesjyu at April 28, 2006 01:25 PM