Database with many changes

0

Situation

I'm making a system for a drugstore. The Client can enter the pharmacy and take products only from the gland and pass directly in the box, or you can pass the counter and just take the antibiotic at the counter with a pharmacist, or you can also go through the counter and the gyndula and then pass in the box. p>

When the client walks over the counter to get an antibiotic with the package leaflet, he receives a command with a number , and the order number is tied to the antibiotic he took with the pharmacist. >

If the customer picks up a product on the gland, the product will not be placed in the order, he can pass the product directly into the box.

When the customer passes the box, whoever is in the box places the order number (if any) that will display the products taken at the counter plus the products taken on the gland (if any). Once the purchase is complete, the system erases the command data.

My Problem

The command constantly varies stored data Compensates to store the command data in MySQL? Or is there a way to pass this change in a more efficient way by reducing the changes in MySQL? What would be the best method?

I've been thinking that it would be great if I had an array to store these products in the command, and if I had a way to pass this array between the counter computer and the box computer.

I am open to suggestions, which language would be most appropriate? What should I use? What is the method?

Additional Information

  • It is being developed using HTML, JS, PHP and MySQL.
  • Will be hosted on an Ubuntu Server
asked by anonymous 30.08.2017 / 00:02

1 answer

1

If the problem is only this, you can create a system of communication between computers with AJAX and save via cookie in the browser. But I recommend you use the database to store for ease and also because of the persistence that is greater, in order to send and receive data AJAX would need all the computers on the network, if any computer "stopped" then data would be lost , which would not happen with the database. In case the client also wants a system to another platform, it would be much easier to implement later with the server already running everything right ...

    
30.08.2017 / 02:11