[FX.php List] Faster record creation?

[Ernest Cunningham]

I just checked and fx.php does not have an sql query interface for  
Filemaker. I only mentioned it because we wrote a plug-in for doing  
event based triggering of scripts and SQL queries to the FM database  
from FileMaker Pro. often it was used to creat large lists of records  
in a table based on what was typed in a given field or chosen from a  
drop down list etc. This performed extremely favourably than doing it  
from a script.
That said even if the Execute sql script step was web compatible I am  
sure it is for external sources only using ODBC (the plugin ran sql  
queries in the background against the FileMaker database not an  
external source).

So My suggestion was rubbish.

Also I would love to know how you did record imports and exports  
called form PHP as they are not Web compatible?



Kind regards,

Ernest Cunningham

__________________________________________________________

   FileMaker Database Developer
   Christchurch,  New Zealand

   Ernest Cunningham
   Mobile: +64-21-40 66 75
   Web Site: www.ging.co.nz
__________________________________________________________

On 17/09/2008, at 2: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