[FX.php List] FM Scripts vs. PHP

[Gjermund Gusland Thorsen]

The answer lays in maintenance, if the php task and the ScriptMaker
task can bring maintenance issues, make both in FileMaker if possible.

If not make one script for each medium.

ggt667

On 10/25/07, Dale Bengston <dbengston at preservationstudio.com> wrote:
> Derrick is dead on: it depends. There are certainly cases with our
> existing clients where we are tapping into a process that invoke
> complex scripts that are part of a client-server installation. In
> such cases, it doesn't make sense to replicate the process in PHP.
>
> On the other hand, we are doing all new development so that it can be
> switched between FMP and MySQL. This means no related fields on
> layouts and no native FMP scripts. It's amazing how much faster data
> retrieval is without any related fields on a layout.
>
> So for us, it's a matter of how tied to FMP we want to be. Since we
> choose to support more than one data source, we do as much as
> possible in PHP. But in certain cases for existing FMP clients, it's
> easier (and cheaper) to tap into the existing scripting.
>
> Dale
>
> PS I concur with everyone who's commented about the pre v7 use of FMP
> scripting from the web: it is ugly. On the other hand, I used to do a
> lot of stuff with AppleScript and v6 from the web. Ah, those were the
> days.
>
>
> On Oct 24, 2007, at 9:04 PM, Derrick Fogle wrote:
>
> > On Oct 24, 2007, at 7:34 PM, Joel Shapiro wrote:
> >> Anybody else care to pipe in?
> >
> > As always, it depends what you're doing. If your operations are
> > mostly native FM with only a small web-based presence, sticking
> > with FM is probably the best choice. But I can't recommend using FM
> > scripting, or even FM at all, if you're good with PHP and your
> > operations are primarily web-based.
> >
> > FWIW, I use FM8SA one one machine, and Apache/PHP on a nearly
> > identical 2nd machine (both XServes). Processing data in PHP is so
> > much faster than processing data in FM, it's not even funny. I'm
> > competent enough with both FM and PHP, and I invariably fetch the
> > minimum raw data required out of FM with as few actual interactions
> > with FM as possible, and do any processing needed for output to a
> > browser with PHP.
> >
> > I can see where, if you want to update a whole bunch of FM records
> > with a single web submit, you will find a point where processing in
> > FM will be faster than processing in PHP, simply because of the
> > time overhead of getting data in and out of FM. But I would
> > question any web application that modified a whole bunch of records
> > with a single web submit.
> >
> > Derrick Fogle
> > derrick at fogles.net
> > _______________________________________________
> > 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
>