[FX.php List] Faster record creation?

[Ernest Cunningham]

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