[FX.php List] Faster record creation?

[John Funk]

My final test and the one I am sticking with is one where the records are
created in FileMaker with a FileMaker Script. I call the script from FX/PHP.
It takes 7 seconds vs 65-70 seconds creating the records with the same
looping script structure.
BTW the FileMaker script runs 10x faster as a faceless process (called from
php) rather than running the FM script on a FM client, even without screen
refreshing.

John Funk


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
Sent: Tuesday, September 16, 2008 11:36 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Faster record creation?

Very interesting, in a bummer sort of way. I'm curious... did you try  
this with no data returned on record creation?

	$ReturnedData = $InstanceName->FMNew($returnDataSet = false);

Dale


On Sep 16, 2008, at 5:43 PM, Tim 'Webko' Booth wrote:

>
> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list