Go to Related Records slow on large found sets

Discussion created by rnovakov on Jan 12, 2012
Latest reply on May 3, 2012 by DavidJondreau

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.


Screen shot 2012-01-12 at 5.00.40 PM.png


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.