[FX.php List] Faster record creation?

[Gjermund Gusland Thorsen]

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
>