[FX.php List] Faster record creation?

Glenn Singleton glenn at possiblesolutions.com.au
Tue Sep 16 16:29:57 MDT 2008


John

How about having "blank" records already created and just adding the values
?

Just another untested thought...

Regards
Glenn Singleton


2008/9/16 Joel Shapiro <jsfmp at earthlink.net>:
> Do you need the 1064 child records *immediately* after the parent 
> record is created?  Could you have a create-children script run either 
> as a schedule in FMServer, or via an FMP client robot machine?
>
> -Joel
>
>
> On Sep 16, 2008, at 11:26 AM, Anders Monsen wrote:
>
>> Could you create the records via a FileMaker script, then search for 
>> the newly created record and display this, as part of the script?
>>
>> I have not executed scripts via FX, but have done so successfully 
>> several times using the PHP API with multiple parameters. If the 
>> script can do all the work for you, the question then becomes how 
>> quickly can the script create these records.
>>
>> Anders Monsen
>>
>> On Sep 16, 2008, at 9:07 AM, John Funk wrote:
>>
>>> I am not sure if SQL will be faster, I am looking for feedback.
>>> Is there a snippet of code somebody can paste here to get me started 
>>> in creating records in FM via SQL / FX?
>>> John
>>>
>>>
>>> On 9/16/08 3:36 AM, "Ernest Cunningham" 
>>> <ernest.cunningham at gmail.com>
>>> wrote:
>>>
>>>> What about using an sql query to create the records in FM?
>>>>
>>>> Kind regards,
>>>>
>>>> Ernest Cunningham
>>>>
>>>> __________________________________________________________
>>>>
>>>>  FileMaker Database Developer
>>>>  Nelson,  New Zealand
>>>>
>>>>  Ernest Cunningham
>>>>  Mobile: +64-21-40 66 75
>>>>  Web Site: www.ging.co.nz
>>>> __________________________________________________________
>>>>
>>>> On 16/09/2008, at 5:21 AM, John Funk wrote:
>>>>
>>>>> 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
>
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list