This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data transfer between Point-of-sale terminal to Server

 
Gunasekaran Gajendran
Greenhorn
Posts: 5
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Advance Thanks....

- Guna
 
Steve Luke
Bartender
Posts: 4181
21
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Gunasekaran Gajendran
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Thanks Steve,

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.

Thanks
Guna
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13061
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For transmission, consider using a messaging approach to avoid loading up the server side with simultaneous requests (if there are lots of clients.)

XML - the great advantage is that as a text format you can create test documents easily, XML is bulky but can be zipped to a compact format.
CSV - practical if the data structure is simple enough

Bill


 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic