[FX.php List] Faster record creation? (resolved)

[John Funk]

Jonathan, Great idea, I even tried that before but the situation is that
multiple users are on the system at the same time and the pre-created
records need to be available for every user to assign the child records the
parent ID.

Here are my findings on this issue:
1. One layout made just for creating records with only the two fields is
best.
2. No Timestamp fields, this caused an approximate 30% increase in record
creation time, even when not on layout.
3. The Created and Mod date fields seem to have little effect on timing.

The final answer that I am implementing is:
4. I created a script in FileMaker to create the records and assign the two
keys for each record. I called the script using:
$request->AddDBParam('-script', 'fmScriptName');
Creation of 1064 record takes about 7-10 seconds. I do not know why I did
not try this first.

Thank you everybody for input.


John Funk




On 9/16/08 11:13 AM, "Jonathan Schwartz" <jschwartz at exit445.com> wrote:

> 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
>