I have a database that is hosted by a cloud company. This particular issue is with a contact table and a contact found set table.
On the found set layout I have a portal to foundset line items (via contacts). When the found set record is opened I often get a sorting window pop up that can take quite some time to finish. Quite annoying.. In the portal can be hundreds of records and when I turn off the sorting it works fine so that is definitely the issue.
Is there any way around this? Seems like they sort every time you go to the record..
The portal does need sorting by surname really to make things user friendly.
Any thoughts would be great..