npsp.TDTM_Contact: System.LimitException: Too many SOQL queries: 101

(i). Group the contacts to appropriate Household Account to ensure huge number of contacts are not associated under single Household Account and try to update the contact's address in NPSP.

(ii). If custom code is used, The error "Too many SOQL queries: 101" occurs when the number of SOQL queries executed in a single transaction exceeds the governor limit of 100. Here are some steps you can take to resolve this issue:

1. Review and Optimize SOQL Queries:
   - Ensure that your code is not making unnecessary SOQL queries within loops.
   - Use collections (like lists, sets, or maps) to store data and reduce the number of queries.
   - If you need to change the context, you can use @future annotation which will run the code asynchronously.
2. Disable Unnecessary Triggers:
   - If there are triggers that are not required for your operation, consider disabling them temporarily.
3. Batch Processing:
   - If you are processing a large number of records, consider using batch processing to handle them in smaller chunks.

Best practices to avoid exceeding the Governors Limit:

Since Apex runs on a multi-tenant platform, the Apex runtime engine strictly enforces limits to ensure code doesn't monopolize shared resources. 

• Avoid SOQL queries that are inside FOR loops.
• Follow the key coding principals for Apex Code in our Developer's Guide.
• Review our best practices for Trigger and Bulk requests: Best practices for Triggers and Bulk requests 

For more detailed information, please refer to the following documentation: https://help.salesforce.com/s/articleView?id=000386220&type=1