[FX.php List] [OFF] Duplicate Record in different Table

[Gjermund Gusland Thorsen]

But is the triggering mechanism reliable enough?

I have solutions where I tried to trigger a script from FX.php and it
only worked 9 out of 10 times.

ggt

2009/1/6 Bob Patin <bob at patin.com>:
> I'm doing a project now with scripts; it's the first time I'm using them,
> but it's the fastest way.
>
> In a database with a over 200,000 records, I pull in 1400 or so records in a
> script, go thru them, sort them by department, count each dept., get a sum
> of some other variables for each department, and then write all of this into
> a single field. I pull that back to the web using a simple URL that runs the
> script, and then construct graphs using the returned data.
>
> Compared to doing all of this on the web, it's tons faster; I have to credit
> my collaborator on this project with the testing and decision to use scripts
> rather than all-PHP in the design. When tests were run, it was obvious that
> scripts were the way to go. Also, it's a lot faster and easier to construct
> the queries in scripting rather than in PHP, because of the tests I have to
> do on the data as I'm looping thru the foundsets.
>
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> Twitter: bobpatin
> iChat/AIM: bobpatin
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance & TechNet
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
>
>
> On Jan 6, 2009, at 2:47 PM, Jonathan Schwartz wrote:
>
>> It's been pounded in my head not to use scripts.
>>
>> That being said, I went ahead and did it the brute force way.
>>
>> I just know that S Winter will come along and give me a 6 line jewel when
>> the sun rises in London.
>>
>> J
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>