How long is "too long"?
What fields do you sort to get the order that you want? Are they indexed fields?
Is the file on your computer, hosted on a computer over your LAN, hosted from a remote site? Are you using an iOS client when you try to sort these records?
Do you really need to see all 12,000 records in your found set at one time? (If you pulled up a much smaller number of records at a time, the time taken to sort them becomes much shorter.)
"(If you pulled up a much smaller number of records at a time, the time taken to sort them becomes much shorter.)"
That would be great. How do I pull up the last say, 2000 records at a time?
What makes them the "last" 2000 records? The most recently created 2000 records or are these the last 2000 records after you sort them into a different sort order than the unsorted "creation order"?
Yes, most recently created 2000 records in list view, newest record at the top of page.
Show All Records
Go to Record/Request/Page [First]
Omit Multiple Records [ no dialog ; Get ( FoundCount ) - 2000 ]
Sort Records [ Restore ; no dialog ]