I would like to access some information about standard tips and tricks for ensuring the fastest possible functions in a file: loading layouts which draw from several tables, processing calculations and scripts, etc. I have a contract database which works well enough on my new computer, but the people for whom I am designing it do not have as fast a system. Can anyone refer me to a published set of guidelines, either online or in print, that would help me identify every possible way to speed up the operations within the file?
I am using FMP 10 on Windows 7 and on Windows XP. The file will be running on the client's H-P computer, Pentium(r) 4, 3.20 GHz, with 1GB of RAM.