[FX.php List] Faster record creation?

[Tim 'Webko' Booth]

On 17/09/2008, at 5:20 AM, Gjermund Gusland Thorsen wrote:

> Theoretically it's faster to create those 1064 records through XML RPC
> than through ScriptMaker...
> So I'd say you are going the right way, but 70 secs... that sounds a  
> bit slow.

Well, for kicks I went and created a page that creates 1000 records  
and puts in only $i to one field and the auto-generated ID to another  
field. No relationships, nothing else in the table except the two  
fields, one layout - as simple as it is possible to go really.

77 seconds average on 5 runs

Now that server isn't great - Dual 1Ghz G4 with 1.25 GB RAM, 10.4.1  
running FMSA9 - but creating large recordsets does seem to be slow.

Cheers

Webko