[FX.php List] Faster record creation?

[Joel Shapiro]

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