[FX.php List] Faster record creation?

[Dale Bengston]

Hi John,

You mentioned that the record creation is the slow part. Are there  
calculation fields in your child records? Summary fields? These can  
slow dow record creation considerably.

Dale

On Sep 16, 2008, at 8:04 AM, John Funk wrote:

> The layout I have to use with FMNew() has only the two fields I am  
> writing.
> Thanks
> John
>
> On 9/16/08 2:56 AM, "Gjermund Gusland Thorsen" <ggt667 at gmail.com>  
> wrote:
>
>> The lower the amount of fields on the layout used for record  
>> creation,
>> especially on the child records, the faster the FMNew()
>>
>> ggt
>>
>> 2008/9/15 John Funk <csinfo at criticalsolution.com>:
>>> 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