Skip to main content
Previous section   Next section


Ensure that the server and client cache are in sync.


[SQL]    ECPSync=n

n is either 1 or 0. The default value is 0.


When ECPSync is enabled (n = 1), each time a SELECT statement is executed InterSystems IRIS® data platform forces all pending Enterprise Cache Protocol (ECP) requests to the database server. On completion, this guarantees that the client cache is in sync.

ECP is a distributed data caching architecture that manages the distribution of data and locks among a heterogeneous network of server systems. For further details, refer to Queries and ECP in the “Querying the Database” chapter in Using InterSystems SQL.

Changing This Parameter

To set the desired value for ECPSync from the InterSystems Terminal, use the SetECPSync() method of the %SYSTEM.SQL class. See the class reference for details.

You can also change ECPSync with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).