We are using a windows service to load about 60 attributes from external database into CRM 2016 (which is working fine). The service picks top 2000 records in the database and sends it to the CRM. Also, if there are any updates made for these 60fields in CRM,the plugin should send updated fields & values to the external database.
Every week we receive about 150k+ records that needs to get updated in the CRM. The issue is when the service update the value in CRM, the plugin is treating it as a change and getting triggered which is making the application slow.
System job show messages as :
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Is there a better approach to avoid plugin to fire when the service updates the value in crm??
*This post is locked for comments