I just ran a quick test
- copied my giant database to three differnet macs
- ran one of the long-running batch processes (updating the trigger field in about 35000 records in a complex join table, which does a ton of auto-enter calcs which pull from multiple related tables). Stopped each one at 300 seconds.
- I ran this test locally in FMPro (rather than FM Server) so it's not an exact test, but should give a rough idea of cross-machine speed
Results (records per time : relative to baseline):
- 3000 : 1.0x : Mac Mini 2012 (Intel i7) macOS 10.13, FileMaker Pro 18
- 6000 : 2.0x : Macbook Pro 2019 (Intel i9) macOS 12.2, FileMaker Pro 19
- 9000 : 3.0x : Mac Mini 2020 (M1) macOS 12.2, FileMaker Pro 19
These results suggest I may see a roughly 3x speedup by moving to a M1 mini - whether that's purely hardware or a combination of hardware/sofware I don't know (and in some sense, don't care).