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

[Greg Lane]

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.