Performance improvement of client server system
Posted
by Tanuj
on Stack Overflow
See other posts from Stack Overflow
or by Tanuj
Published on 2010-04-02T18:13:14Z
Indexed on
2010/04/02
18:23 UTC
Read the original article
Hit count: 237
I have a legacy client server system where the server maintains a record of some data stored in a sqlite database. The data is related to monitoring access patterns of files stored on the server. The client application is basically a remote viewer of the data. When the client is launched, it connects to the server and gets the data from the server to display in a grid view. The data gets updated in real time on the server and the view in the client automatically gets refreshed.
There are two problems with the current implementation:
When the database gets too big, it takes a lot of time to load the client. What are the best ways to deal with this. One option is to maintain a cache at the client side. How to best implement a cache ?
How can the server maintain a diff so that it only sends the diff during the refresh cycle. There can be multiple clients and each client needs to display the latest data available on the server.
The server is a windows service daemon. Both the client and the server are implemented in C#
© Stack Overflow or respective owner
