disappointed in FMP 9 advanced on latest xserver
I'm very disappointed on the performance of FileMaker Pro 9 Server Advanced on the latest xserver (single core; 2.3Ghz, 8GB memory) running 10.5.6 server.
I've almost no performance gain with this new setup compaired to my old mac mini core 2, 2gb memory and FMPS 9 adv.
The database searching/exporting/relookup are all at the same speed from the past? How to enable FMP server to use the full power of the xserver?
Export 719,000 records out of 3 related tables
- mini: 19 min
- xserver: 18 min
Relookup 1 related field: 450,000 records
- mini: 16 min
- xserver: 15 min 40 sec.
I cannot believe that a mini of 750$ is as fast as 4000$ xserver.
Any ideas on what to do to get dramatic improvement?
Usually the hard drive is one of the biggest factors in speed for a server. You would want to go with a fast HD interface. The older versions of FMS do not really take full advantage of multiple cores. Perhaps you can try to benchmark test on FMS10? It was improved for multiple cores.