FMS11 sort speed enhancement ideas?
I'm was running FMS10 on a dual processor G5(4G ram)(OS10.4), I have had to switch over to FMS11 on a 1.6Ghz mini (running OS10.5.8) with 2G ram and I am getting similar performance. The performance is adequate, but there are occasional delays when sorting records (5 - 15 seconds). What can I do to improve sort speeds. The data base is somewhat complex with the 2 largest related data sets consisting of 30K and 250K records. Should I look at hardware, or would I do better to review my database structure and add a few more fields to be stored sorted.