Related Table search performance

[GregInChrist]

I am looking to increase performance on a search script I have built.

 

I have a layout in list view. I have a button and script that is preforming a search(s). 

 

I believe the search is taking along time due to searching related records via a portal. I am looking to preform a search of a field in the main table I am working from, then only search the related table for records within that found set.

 

I have tried preforming a search then omitting records with the constrainFoundSet script step then showing only omitted records. However it seems to take just as long as just preforming one search with all my criteria in a single step. 

 

Are there any known best practices to isolating searching to a found set?

 

Thanks in advance and may the Lord bless you!

[Matthew F]

If you have multiple search criteria you can break the search into multiple steps.  First do a 'Find' based on indexed fields.  Then do a second search on your non-indexed, calculated or related fields using 'Requests > Constrain found set'.

[GregInChrist]

Perfect, thank you!