Controls the frequency (in milliseconds) of client/server synchronization.
This property’s name, which is used in the connection string, is Auto Synch Period.
The default on the server is 10,000 milliseconds (10 seconds).
By setting this property to a NULL value or 0 (zero), automatic synchronization is turned off, and synchronization does not occur at a constant interval. The frequency of synchronization depends on client activity.
Because some client queries are resolved solely from client cache, too high a value in this property can more frequently result in query results that do not reflect recent updates in the data source. A sufficiently low value can reduce the likelihood of these events. However, too low a value can impede performance. The lowest, valid, non-zero value is 250 milliseconds. If a value between 1 and 249, inclusive, is specified, a value of 250 milliseconds is used.
This property’s value is used when a session is established, but the value cannot be changed during the session.