AnsweredAssumed Answered

Yesterday's data for accounting

Question asked by siplus on Jan 20, 2015
Latest reply on Jan 20, 2015 by wimdecorte

Hi all,


Our solution - about 5 GB for this particular client - is used 6 days out of 7 by people that input, modify and consult the data. Think at a clinic/hospital as a close example.

Their interaction with the system must be as smooth and fast as possible.


On the other hand, we have the accounting people; their primary hobby is to run statistics and reports on the system, all the time.


These people's interaction with the data (they are situated at a remote location via Citrix, just to make the whole sweeter) should have the minimal impact on the work of the main team. From experience, I know that some reports they are entitled to start will run for 6-10 minutes before delivering the results. As of now, during this time, the team 1 experiences spinning beach balls and text input that only appears in the fields after 3- 10 seconds, completely unacceptable.


In order to achieve this (minimal impact from team 2 on team 1's work), what I would like is: create a configuration in which there are 2 servers.


Server 1 hosts the live data and is only accessed by team 1. In the evening, all the data gets copied to Server 2. Team 2 (accounting) will only have access to "yesterday's data". They can massacrate the Server 2 with all their weird requests, with no impact on Team 1, fully knowing that what they see is one day late over the real thing. They can accept that.


So 2 servers, 2 different IP addresses, 2 Filemaker Pro servers. But how would you implement this, concretely ?

(data copy, start stop servers etc).