Hello everyone, I need to create a record which will be attached to the contact record type. I'm wondering if when searching for specific records for one contact will it have to search through the list of all records? There could potentially be a large number of records with multiple records associated with one contact so I'm worried about the performance impact this may cause. Also, if possible is it faster to search the contact itself and just load the records associated with that one? It seems that maybe it would be doing the exact same thing in the end. If anyone has any insight as to how the search would actually be performed or ideas on how to improve performance that would be great.

Your custom record won't be searched when you search for contacts, unless you intentionally add it as a join in the filters or result columns.

Thank you for the response. That's good news because I've already committed to doing it this way!