I have a solution that has two tables, where Main has approx. 150,000 records and Secondary has approx. 450,000 records.
The Relationship Graph is pretty straight forward and looks like this. Both key fields are fully indexed.
I am trying to find records in the Secondary table and then show all related records from the Main table using the Go to Related Records script step, navigating to a layouts that has fields from the Main table.
If the found set is quite large, then the Go to Related Script step takes a long time, with a Find progress bar appearing.
Is there any way of speeding things? Appreciate your comments and ideas.
PS: I am attaching a sample file as well.