SQL Server Compact 3.5 enables you to synchronize data between a SQL Server Compact 3.5 database and a SQL Server database. Because synchronization is performed over TCP/IP, it is supported over various networks and bandwidths.
To optimize performance, you can modify the settings based on the bandwidth of the network connection. The following table shows the bandwidths used by some of the TCP/IP networks supported by SQL Server Compact 3.5.
When data is synchronized over a cellular or mobile network, requests sent to the server—and responses from the server—can time out. This occurs when a low-bandwidth connection requires too much time to transmit the data. Because time-outs will cause synchronization to fail, specify a longer time-out value.
However, if time-outs are not a problem, set shorter time-out values because a delay in response from the server over a high-bandwidth connection is more likely caused by an unresponsive server. Therefore, applications that run on the desktop and connect to the server over a LAN and devices that connect to the server by using an ActiveSync connection should use shorter time-out values.
Applications that connect to the server over various types of networks should detect the network bandwidth and set appropriate time-out values.
The following table provides recommendations for setting the time-out values, depending on the network bandwidth.