[FX.php List] Update a field in all related records.

[Dale Bengston]

I'm with Greg on this one. FMSA is not single-threaded to the web in  
my understanding. It most definitely is in v6 and before. I have  
found judicious use of FMP scripting to be acceptable in many  
situations, but there are many other situations where I would not use  
them. I think Greg's rule of thumb about not editing records via  
FX.php in looping situations is a good example.

-Dale

On Mar 19, 2006, at 11:33 PM, Greg Lane wrote:

> Hi Kevin,
>
> I agree with many of your points, if you're talking about version 6  
> or prior. Do you have these same concerns with FMSA 7/8? I've found  
> using FM scripts to be a good way to reuse business logic across  
> FMP/IWP/CWP interfaces (but unfortunately not xDBC). FM scripts can  
> also be a very useful tool for performance optimization  
> (particularly for complex finds and multiple edits/deletes).
>
> Greg
>
> On Mar 19, 2006, at 8:07 PM, Kevin Futter wrote:
>
>> Actually, the "rule of thumb" is generally to avoid running FM  
>> scripts from
>> the web if at all possible. They represent a security weakness,  
>> they can be
>> slow and error-prone (which is a particular problem if you're not  
>> capturing
>> the errors), and they also affect performance on busy machines.  
>> Since FM's
>> web engine is single-threaded, each request has to queue behind  
>> the one
>> running, and FM scripts only exacerbate this by slowing down the  
>> current
>> request.
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list