AnsweredAssumed Answered

Speeding up a large sorting operation

Question asked by KevinPfeiffer on Apr 11, 2011
Latest reply on Apr 11, 2011 by philmodjunk


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... ?