sfpx

Record creation speed and occurrences

Discussion created by sfpx on Apr 11, 2016
Latest reply on Apr 13, 2016 by sfpx

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

speed.jpg

 

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 ?

 

Notes:

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"

Outcomes