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

[Dale Bengston]

Joel,

Thanks for more great metrics.

It also makes sense to tap scripts if you're web-enabling an existing FMP client-server system. The workflow's already there.

It's often a series of tradeoffs, though. Avoiding scripts to use ODBC may be slower when adding 20 child records, but if the rest of the queries on a site are faster, it still might be worth it. I have one client with a very complex system that might benefit greatly from a switch to ODBC.

Dale


On Aug 20, 2012, at 11:41 AM, 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