News for hackers. Stuff that matters.
Re:How Not To Sort By Average Rating by trezor on Friday February 13, 2009 @08:52AM (#479833)
Custom functions mean no caching

This only applies if you are using a sub-par database. While caching computationally heavy operations is not always a good choice (since they will need to get updated when more entries are added to the dataset), chances are you will have orders of magnitudes more lookups than writes and hence it makes sense to create a computed column and index the results (and hence cache them).

There are no comments on this comment yet.