Speeding up a large sorting operation
A question mostly for Phil, I guess. It's spawned by the comment earlier in another thread about speeding up operations with large data sets. For a standard sort (say, the sorted condition in which you prefer to always find a particular set of records), what about storing a sort key that is then updated nightly (or whenever)? You sort the large data set once a day, for example, then re-assign a serial number to a sorting field based on the current sorted condition... ?