2009-08-30, 02:16 PM
Stereo Wrote:As long as you do a few precalculations when you change the list (sorting into a tree by probability and calculating the total probability are good) you can keep it pretty smooth. Dunno if it's done automatically by SQL.
The problem there is that the people who update the list have to be aware of the need to do that, and a slight fudge can skew the entire table. Since the table itself is generally just a collection of IDs and Values edits to it can easily have unintended effects if you don't fully understand what it's doing and don't have an interface that makes the results clear by showing you the calculated effect of the change.
It's not having what you want - It's wanting what you've got.