Im developing application for point-of-sales. Usually server and POS terminal are discounted however those will be connected when data required for server or client. Server has 1,00,000 items in DB.
Daily client fetch the items details from server and send the sales details to server. Server side application is Spring and client side is VB.Net.
How to transfer data between POS terminal and server with out affecting performance of Server,DB, Client side and Network.
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.
Joined: Jul 11, 2012
Amount of data transfer rate is huge in this application.
Please suggest,which format (XML,CSV) and methodology (Webservice,RESET) is best for transferring the data from server to client and vice versa.