[FX.php List] Connecting PHP Web Pages with ODBC

[Dale Bengston]

I second John here. Good layout discipline makes all the difference. Avoid calc fields, summary fields, related fields and portals where possible. And always design specific layouts for use by FX.php, separate from client-server layouts and distinct for each purpose of your web site. Forty layouts that do one thing well are better than five layouts that get used many instances.

Dale

On Apr 25, 2013, at 11:55 AM, John Funk <csinfo at criticalsolution.com> wrote:

> When creating records  with Fx you have to be sure and use an optimized layout created just for that purpose. Do not use fields that you do not need. With FX all information is inserted/extracted using the Fmresult xml file and that file is created by what fields are on the layout you are using in the query.
> I have created millions of records with a layout that has 3 of 34 fields and it was very fast. Another hint is to not have related or portals on the layout, if you need to create records in a related field of to a layout for that table using a key. The PHP code seems clunky but I found it to be fast.
> I also have seen ODBC queries  take a long time especially when modifying a found set. 
> 
> The best thing about FX is NO DRIVERS are required so it is more flexible and you can actually use PHP command lines in DOS or MacOS bash commands.
> John
> 
> From: Glyn Devine <glyn.devine at quickseries.com>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Thursday, April 25, 2013 11:28 AM
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [FX.php List] Connecting PHP Web Pages with ODBC
> 
> ODBC will definitely be faster than FX. FX is dead slow when writing records. You are generally talking multiple seconds per record created. 
> 
> To use ODBC to write to filemaker in PHP, you will need to install the FileMaker ODBC driver on the same machine PHP is running on. The driver that comes with FileMaker 11 will work fine. I do not recommend the FileMaker-created ODBC drivers from FileMaker discs prior to version 11 – these also have some pretty terrible speed problems.
> 
> Good luck! 
> 
> 
> 
> On 13-04-25 11:47 AM, "dealTek" <dealtek at gmail.com> wrote:
> 
>> Hi all,
>> 
>> I am looking for a way to do CWP web pages with php and connect not with filemaker php api which seems to use XML which appears to be slower but maybe with ODBC which I hear might be a faster transfer rate....
>> 
>> 1 - Do you know if using ODBC is possibly faster than filemaker php api for faster web data transfers?
>> 2 - Can I accomplish this with just the supplied client odbc code or would it be better to use fx.php?
>> 
>> --
>> Thanks,
>> Dave - DealTek
>> dealtek at gmail.com
>> [db-3]
>> 
>> 
>> _______________________________________________
>> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20130425/632404b0/attachment.html