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

[John Funk]

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

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

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