Best Practices and Guidance for "Apex CPU time limit exceeded" in Data Mapper

"Apex CPU time limit exceeded" occurs in Data Mappers if the transaction exceeds the governor limits. Governor Limits will get hit because of the amount of time processing done. There is not a guarantee that "X" number records will be able to be processed under the CPU Governor limit.

When configuring a LIMIT filter setting under the Data Mapper, the maximum number of records returned within the allowed values from 1 to 2000, there is NOT a guarantee that the  limit amount of records will be able to be processed under the specified limit. Utilizing a LIMIT of 2000 would ensure that the Data Mapper would not hit the governor limit, however, there will be some scenarios where the Data Mapper can process above 2000 records before hitting the Governor Limit error. The 2000 limit is a "safe" limit.

The CPU Governor limitation is the amount of CPU time required to retrieve records. The CPU Time is affected by number of fields, number of records, query parameters, etc. This is not specifically to a limit on the number of records, but rather the amount of time spent processing any set of records.