[FX.php List] Faster record creation?

[Dale Bengston]

Calc fields that are not on the layout still get calculated when data  
is added or modified via the web. Time-stamps and such don't sound  
severe enough to cause a slow-down though.

On Sep 16, 2008, at 10:28 AM, John Funk wrote:

> The table that the records are being created in has creation and
> modification TimeSamp calc fields, recID,  but these are NOT on the FX
> layout for this function. I will try taking  the TS fields out of  
> the table
> but I need the RecID for later editing. Thanks.
> John
>
>
> On 9/16/08 10:17 AM, "Dale Bengston" <dbengston at tds.net> wrote:
>
>> 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
>>
>> _______________________________________________
>> 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