One thing I don't like about Filemaker is that record creation is highly impacted by the number of occurrences.
I'm doing some tests to find a way to speed up my initial sync script ( a lot of records have to be created on an initial sync).
Here's my latest test on a simple database
Creating 20000 records of table B (1 occurrence of B) : 14 seconds
Creating 20000 records of table D (6 occurrences of D): 21 seconds
Creating 20000 records of table F (6 occurrences of F): 15 sec
What can explain this ?
Tables B, D and F are identical copies.
The script is a loop that simply creates 20000 records and set the "_id" field to "x"