I really like the multiple sorting feature for columns on the List Page but I noticed that there are speed variances depending on what you do prior to selecting a Sort of fields.
For example when the List Page is sorted prior to any Searching or Advance Search results the screen refreshes very quickly.
When you perform a Search or Advance Search and then select any column (field) to be sorted it can take anywhere from 1 - 15 minutes to sort and refresh the screen.
In my instance I have a database with single table that contains 1.2 million records (mostly everything is indexed for speed). If I perform an Advance Search and receive only 15 records on the screen (with no other pages) and try to sort those 15 records it takes nearly 5 minutes to sort before the screen refreshes itself. In some rare instances it can take up to 10 or more minutes.
Is the Sort using some form of ordering on the entire 1.2 million records or just the 15 records presented on the screen initially? I would have suspected that it was sorting an array() containing the search results only but maybe it isn't.
If this is the case (all 1.2 million records are being sorted prior to the 15 records being presented on the screen again) how can I find the the php or html string to turn off this feature?