• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Data transfer between Point-of-sale terminal to Server

 
Greenhorn
Posts: 5
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 4179
22
IntelliJ IDE Python Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Author and all-around good cowpoke
Posts: 13078
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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


 
I don't get it. A whale wearing overalls? How does that even work? It's like a tiny ad wearing overalls.
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic