Script Speed - Replace Contents or Loop&Set

[grumbachr]

In a solutions I'm working on I have to import data from another file. To mark the records in the original file as imported I can either do Replace Fields Contents (needs to be done on 3 fields) or I could loop through the records using Set Field on those 3 fields.

Anyone know from experience which method might be faster? On some occasions I could be dealing with thousands of records so any performance gains I can make, I think I should take them.

[David Jondreau]

Replace[] in 3.0!

http://help.filemaker.com/app/answers/detail/a_id/2927/~/two-ways-to-speed-up-looping-scripts

You could put a global calc (or a regular calc) in the source file with whatever text you're using to mark them and import that too.

Edited September 24, 2010 by Guest