[FX.php List] Faster record creation?

[Blair Duncan]

Your results are consistent with this document from Jonathan and Chris

http://jonathanstark.com/web_publishing_with_filemaker_and_php.php

Section III Performance:
Create 1000 records
FileMaker.php: 76 seconds
FX.php: 69 seconds


Using a script step to create 1000 records takes 5 seconds.



On 9/16/08 3:20 PM, "Gjermund Gusland Thorsen" <ggt667 at gmail.com> 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.
>
> ggt
>
> 2008/9/16 Joel Shapiro <jsfmp at earthlink.net>:
>> Do you need the 1064 child records *immediately* after the parent record is
>> created?  Could you have a create-children script run either as a schedule
>> in FMServer, or via an FMP client robot machine?
>>
>> -Joel
>>
>>
>> On Sep 16, 2008, at 11:26 AM, Anders Monsen wrote:
>>
>>> Could you create the records via a FileMaker script, then search for the
>>> newly created record and display this, as part of the script?
>>>
>>> I have not executed scripts via FX, but have done so successfully several
>>> times using the PHP API with multiple parameters. If the script can do all
>>> the work for you, the question then becomes how quickly can the script
>>> create these records.
>>>
>>> Anders Monsen
>>>
>>> On Sep 16, 2008, at 9:07 AM, John Funk wrote:
>>>
>>>> I am not sure if SQL will be faster, I am looking for feedback.
>>>> Is there a snippet of code somebody can paste here to get me started in
>>>> creating records in FM via SQL / FX?
>>>> John
>>>>
>>>>
>>>> On 9/16/08 3:36 AM, "Ernest Cunningham" <ernest.cunningham at gmail.com>
>>>> wrote:
>>>>
>>>>> What about using an sql query to create the records in FM?
>>>>>
>>>>> Kind regards,
>>>>>
>>>>> Ernest Cunningham
>>>>>
>>>>> __________________________________________________________
>>>>>
>>>>>  FileMaker Database Developer
>>>>>  Nelson,  New Zealand
>>>>>
>>>>>  Ernest Cunningham
>>>>>  Mobile: +64-21-40 66 75
>>>>>  Web Site: www.ging.co.nz
>>>>> __________________________________________________________
>>>>>
>>>>> On 16/09/2008, at 5:21 AM, John Funk wrote:
>>>>>
>>>>>> I have a solution that when a new company is entered and record
>>>>>> created it
>>>>>> also creates 1064 records in a child table. I am looking to
>>>>>> streamline the
>>>>>> process so instead of taking 70 seconds to create the records it is
>>>>>> somewhere around 30 seconds. Any feedback will help.
>>>>>>
>>>>>> This is the current looping process:
>>>>>> 1. Create new parent record. (Company)
>>>>>> 2. Find records from the category table (Category) (1064 found)
>>>>>> 2a. For each found Category, create a record in Company_Category
>>>>>> with CompID
>>>>>> and CatID.
>>>>>>
>>>>>> There are a few other methods I have tried with marginal improvement.
>>>>>> 1. Perform the record creation in FileMaker with a looping script
>>>>>> called
>>>>>> from PHP.
>>>>>> 2. Perform the record creation in FileMaker using exports and
>>>>>> imports called
>>>>>> from PHP.
>>>>>> 3. Created a duplicate FM Layout with just two fields for FX to
>>>>>> create the
>>>>>> Company_Category records.
>>>>>>
>>>>>> I have looked at the FileMaker record counter diring tests and the
>>>>>> slowness
>>>>>> is NOT in the Find Category, it is in the record creation.
>>>>>>
>>>>>> Any ideas on creating records faster?
>>>>>>
>>>>>> John Funk
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>
>> _______________________________________________
>> 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
>


Please consider the environment before printing this e-mail.

This message and any attachments contain information, which may be confidential or privileged. If you are not the intended recipient, please refrain from any disclosure, copying, distribution or use of this information. Please be aware that such actions are prohibited. If you have received this transmission in error, kindly notify us by e-mail to helpdesk at bbdo.com. We appreciate your cooperation.