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

[Kevin Futter]

On 17/3/06 4:22 PM, "Joel Shapiro" <jsfmp at earthlink.net> wrote:

> Hi Greg
> 
> I'm surprised (pleasantly!) to hear that calling an FM script could
> have better performance than having PHP do all the processing.  I've
> got a project doing something similar to Joe's task, and I use an FM
> script, but I'd thought I was just being lazy and that an "all PHP"
> solution would be faster/stronger/more reliable... (and that maybe
> I'd get around to switching it someday ;)
> 
> Are there any guidelines or 'rules of thumb' about when using a
> FileMaker script is preferable to PHP scripting?
> 
> Best,
> -Joel

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.

-- 
Kevin Futter
Webmaster, St. Bernard's College
http://www.sbc.melb.catholic.edu.au/