[FX.php List] Faster record creation?

[John Funk]

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