[FX.php List] ODBC Selects and Inserts VS FX/XML Speed test

[Joel Shapiro]

Hi

Just a quick comment that FM scripts can sometimes perform a LOT faster than trying to do everything just on the "web" end.

I used to never use FM scripts but have found that they can sometimes save time in both development *and* performance.

A while back I tested speeds of different ways to add multiple related records:
http://blog.jsfmp.com/post/19243201571/adding-multiple-related-records-in-filemaker-php

NOTE:
a) I tested only in the API but I'd imagine the differences would be comparable in FX
b) I did *not* test ODBC

-Joel


On Aug 20, 2012, at 8:09 AM, BEVERLY VOTH wrote:

> 	* let the web app do the "heavy lifting" (instead of scripts, use the web app - and YES, I know that's *more* work...)