I have an application which utilizes a local database cache to synchronize bidirectional changes between the client and the server. Most of the changes occur at the client level, so most of the changes are being synchronized from the client to the server.
In my usage case, the clients are connected 99% of the time, and the local cache is just a safety net to avoid accidental disconnection from the server because the clients are often connected wirelesly. I am currently synchronizing the databases every time
the client adds new data (it really is not as bad as it may sound given the exact use of the program), but this is very inefficient and causes a momentary lag in the program as the data is synchronized. Is there a way automatically propogate the data to both
the client and the server so that I don't have to run the sync when the client is actively connected? or does it actually do this already and I am just duplicating something that already exists?
View Complete Post