Gunasekaran Gajendran wrote:How to transfer data between POS terminal and server with out affecting performance of Server,DB, Client side and Network.
That is impossible. Anytime you use the network, you take bandwidth and reduce the possible bandwidth available to the rest of the network, and as such reduce other application's network performance. If you use the DB you will make connections and use computer resources on the DB. Other applications/users trying to use the DB will not have access to the resources you are using so their performance will suffer. The client will use CPU cycles, memory, and network resources taking those resources away from other applications on the client - reducing their performance. Same with the server.
So the only way to do it without affecting performance is to not do it.
Your best bet is to try to make the impact as small as possible:
1) Schedule the transfer to happen on off-times, when it is unlikely to affect applications which require a lot of resources
2) Write efficient code, trying to reduce the memory, CPU, and network bandwidth requirements. Use a profiler to make sure you target the correct portions of your code for optimization. Also realize that trying to reduce the memory footprint and CPU footprint are often contradictory efforts - you will at some point need to choose between memory and CPU (or other resource) footprint.