Server performance OSX vs Windows
So the last few months I've been working on a database solution with filemaker for our small company that we want to implement during the next few months. Now, however, we are not sure how exactly we want to run this solution.
Our current thought is to buy a new, relatively powerful iMac, run the server on this computer and use the same Mac as the main workplace for orders and such.
From this host the thought is that it should be accessible via an iPad in the delivery apartment, a cheap computer with access rights only to implement production examination etc. and a couple of other Windows computers in case we would want to have a look at what's going on in the database. Basically, at any one time we would most likely only have about 4-5 clients accessing the database from the FIleMaker server that's running on the iMac that will run 24/7, and that's it.
Do you think that this is a viable solution, or should we maybe have our own, seperate computer running the server, even though we only have so few clients accessing the database at any one time, and should this computer perhaps be running with a Windows server or what have you?
I'd love to hear any thoughts on this as a I haven't found any reliable guides for such small companies, the only recommendations that I've found searching the web have been based on bigger companies with hundreds of clients accessing the database at the same time, which obviously will not be the case for us.
As a sidenote, we are currently running our database with Microsoft Access with windows computers from a seperate Windows server and will have to, in case of switching to iMac, do the transition to a new OS.
I don't think this will be a problem as most of the programs we use other than Access is supported in OSX.
Also, how well would the automatic back-up work with an OSX FIleMaker server in this solution?
Thanks in advance, if there's anything I forgot to add that could be relevant, please let me know and I will provide you with answers to the best of my knowledge :)