Hi,
I have developed a job bag system with which I am experiencing some performance problems with loops. The system is served by a Mac G4 to around 10 cross platform hosts.
This is my scenario: I have 2 databases - Jobs and Contacts. I go to create a new job, and I am asked to choose who the job is for - the contact. I have a list of available contacts which is a portal. The relationship is based on a global number field in the jobs database, which is set to 1 and a match field which is a number (or flag) in the contacts database which can either be '0' or '1' (so that contacts marked as '1' appear in the selection list). I have a filter function so that, say I know that the contact who the job is for contains 'John', I can type this into a text field and press the filter button, and return all the 'John's' in the contact database in the selection list. This works by first looping through all the contacts setting the number (flag) field to '0', then performing a find and finally setting all the matches number (flag) fields to '1' by looping through them again.
This works fine, but it is slow, can anyone suggest an alternative approach to this, should I be using Filemaker server - would this speed it up?
Many thanks for any help or advice.
Regards
Kevin Price-Ward