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

[BEVERLY VOTH]

+ 1 on that Joel! I guess it really depends on what needs to be done and what's the most efficient for the application! Like the difference between Set Field and a calculation. Sometimes one is better and sometimes the other... :)

Edit multiple related may just be one of those times to script-it! I *love* having a full load of methods to use (or not).

Beverly

On 20 Aug 2012, at 12:41 PM, Joel Shapiro wrote:

> 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...)
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list