Performance improvement for ‘Add’ Action in Synchronization
[2.5] [7.0] [7.01] [application] [Data] [Delta] [Iteration] [Loop] [MI] [middleware] [no synchronization] [performance] [performance bond] [Smart] [Sync] [SyncBo] [Synchronization] [T01] [T51] [time]
Symptom
Middleware is taking a long time to send records for Add action during synchronization for any smartsync application.
Other terms
Smart Sync, Delta, Synchronization, Middleware, Application,
Performance, Time, Data, Iteration, SyncBO, Loop, T01, T51, MI 2.5, MI
7.0, MI 7.01.
Reason and Prerequisites
The SQL query with a clause FOR ALL ENTRIES is executed without condition prior to this query leads [...]