Calling fmpro.evaluate in a loop - scaleability

[john renfrew]

When you call this in a loop

for (i in 1..num){

a = fmpro.evaluate("GetNthRecord($fm_field; $i)")

list = list + (list ? ',' : '') + a

}

It gets exponentially slower

It has just been tested on data sets up to 175,000 today

Is anyone at 360 able to give insight as to why??

[wbasham]

Can you reproduce the same issue in FileMaker using GetNthRecord without using ScriptMaster? Call that function in a script loop and increase the size to determine if you experience the same issue independent of the plugin.

[andries]

GetNthRecord is really slow for large datasets even in FileMaker Pro.

If you create the same loop in FileMaker Pro it will become slower as well as it approaches the end of the record set... For larger datasets it is faster to loop over the records...

[john renfrew]

Andries

We are trying to extend some of Kevin Franks methods to do with creating an ID list for the 'IN' part of an SQL query without doing recursion which breaks anyway...

Am just running proper tests now and I will do some over the weekend to compare it from Filemaker natively