AnsweredAssumed Answered

FMS11 sort speed enhancement ideas?

Question asked by stuarta on Jul 21, 2010
Latest reply on Jul 21, 2010 by MartinBrändle


FMS11 sort speed enhancement ideas?

Your post

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.