Create a mapping table in Rock that stores the Mail Chimp and the Rock PersonAliasId. When matching records, search this table first, if nothing is found, proceed with current matching logic. Once a record is matched, update / create a new mapping in the mapping table. This would greatly increase performance and reliability. We would also be able to remove the Foreign Id code on the Preson Record.
Create a mapping table in Rock that stores the Mail Chimp and the Rock PersonAliasId. When matching records, search this table first, if nothing is found, proceed with current matching logic. Once a record is matched, update / create a new mapping in the mapping table. This would greatly increase performance and reliability. We would also be able to remove the Foreign Id code on the Preson Record.