If you can, limit the number of records to be sorted and the number of fields in each record.
- Since you are producing a summary report, if your summary report is such that the data in any given record represents data from multiple records, investigate whether you can set up a "summary table" where each row of data in your report references a single record in the summary table.
- If you have a large number of fields in each record of your table, consider splitting the table into two parts linked in a one to one relationship. Make one of the two tables have only the fields needed for your report.
- Don't have a script enter this layout while in browse mode, enter find mode, then change layouts, then perform the find.
- See if you can put limits on how many records can be found by controlling what search criteria can be used in setting up this report.
same conversation on FM Forums: Loading sorted records from server - FileMaker Pro 15 Discussions - FMForums.com
(it is a good practice to indicate that you are cross-posting; a lot of the people hang out in different places so it is nice to know whether it is the same topic).