Sorting Unindexednrecords

[MyFM]

Help.....Can anyone help me with speeding up a sort of an unindexed record? Any help will be greatly appreciated and your reward will be in Heaven.

Many thanks

[Kurt Knippel]

Umm, the only way to speed it up is to index them, or to reduce the set of records that you are sorting.

[BobWeaver]

Assuming that the field is not indexable, you can create a new field and use a script to set the new field to the contents of the unindexable field. The new field will be indexable and will sort fast. However, you will have to run the script to update the new field whenever anything in the other field changes. If it doesn't happen too often then you may be okay. Otherwise, you won't really gain any speed, because the script will be as slow as doing the unindexed sort.

[MyFM]

Thank you kindly for your responses. I will keep trying things.