One of my big goals is to get file transfers between the two workstation PCs as fast as possible - so loving the idea of 10/25GBps vs what I currently have.
Am thinking:
- Lots of HDDs in an array to speed up read/write access to maximum possible
- Cat 7 between NAS and PCs
- Decent CPU, RAM and MB to deal with the transfers...
I think you're being starry eyed in notions of fancy spec lists at the moment, and haven't really thought through / specced out the end to end setups of all machines in the network and what you really NEED out of them.
When you say between work stations transfers, is that sending a file directly from Workstation 1 (W1) to Workstation 2 (W2) across the network. Or is it that W1 saves on NAS, and the W2 pulls the file from the NAS later ?
If the former, you would be better spending money on fast storage on the workstations and the network link between them, and worry less about the NAS. If the latter, then all machines will need fast storage and fast networks links.
... but ...
what sort of files are you really going to be transferring between the machines most often? Are they huge multi-gigabyte files getting moved repeatedly, or are they smaller, sub-gigabyte file sizes? I would argue that unless you need significant sustained transfer rates for multi-gigabyte files on a repeated basis, then even normal 1G ethernet will generally suffice and be reasonably performant.
And are you going to need fast access to ALL your data all the time ? Or is it more that you'll be working mainly on a current project folder ( or similar ) and have other folders which are archives of previous projects that you keep to be able to go back into from time to time if needed.
If so, then you can set up tiered storage on things like Unraid and TrueNAS ... so the current project folder could be made to only use fast SSD devices, and the archives sit on different devices like spinning hard drives. The SSDs will give fast response to read and writes. The HDD's will be slower for browsing old projects.
That way, if the bulk of your work is on the current project, then the SSD's will use less power, and the HDD's can spin down when not in use ... greatly reducing power usage.
As I say, I think you need to spec out your actual working practice first, and then try and best match it with hardware. Not the other way round.