[FX.php List] Faster record creation?

[Jonathan Schwartz]

Thinking out of the box...

How about having pre-created child records ready to go, and then 
making the process of adding records a process of assigning records 
to the parent.  For this to be at all feasible, the process of 
assigning the records needs to be faster than creating new ones...but 
it opens up the possibilities.

Just a thought.

J

>I imagine that having the fields indexed also adds some overhead.
>
>Roger
>
>On Sep 16, 2008, at 11:17 AM, Dale Bengston 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


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011