fabiensen Posted February 1, 2014 Share Posted February 1, 2014 Dear, we are working on a Prestashop solution for an on-line shop. However, cashiers at the physical shop should access the DB with iPads and basically dialogue with the on-line installation. Now, we are aware that this question relies on a bunch of variables, but, anyone could tell us which of the two solutions is better, in your opinion, especially if you tried them? Or if you have a third one, very welcome 1) To keep only one DB locally, using iPads and local php web services as cashiers. In this case will the communication between Prestashop and the local DB be too slow? We can have a 24/7 Linux machine and mySQL DB running with its own IP (dynDNS would be enough) 2) To have 2 DBs synched: the data entry would be done on-line and the local DB would be a mirror of the on-line DB. The local DB, however, should update the remote DB about stock quantity. Speaking frankly, which are your feelings about these two solutions, usability, reliability, security, etc? I repeat, we are totally aware that it depends on too many variables. Just guessing... Best regards FF Link to comment Share on other sites More sharing options...
musicmaster Posted February 2, 2014 Share Posted February 2, 2014 I would go for simplicity. If you can run it on one server I would do that. Better to invest something more on the speed of that computer (for example a SSD). The complexer your solution the more potential points of trouble. But I don't have experience with this kind of solution, so you may take my words with a grain of salt. Link to comment Share on other sites More sharing options...
Recommended Posts