1 Reply Latest reply on Jun 9, 2009 8:19 PM by FluffyBear

    PHP upgrade for Advanced Server 10

    peterd42

      Title

      PHP upgrade for Advanced Server 10

      Your post

      This may be useful for someone (maybe not), and I would like a moderator to comment if possible about whether this is something that has been tried, and if I am heading for disaster.

       

      Configuration - FM 10 advanced server running on Windows Server 2003. Clients connect using SSL. Server 3 gigs ram.

       

      Gave up on IWP as it was just not flexible enough for what I wanted to do.

      PHP used to develop a website to connect to Filemaker which in turn connects using ODBC to various SQL databases.

       

      Problem - slow response and various crashes resulting in having to reinstall server twice.

      Cause - even simple PHP requests max out the memory on the machine, killing IIS and WPE. Nothing seemed to fix other than a reinstall.

      Solution - upgrade the PHP that filemaker installs as default from 5.2.6 to the latest version 5.2.9-2. This took about 20 mins to do.

       

      This has improved things. No longer have crashes at startup, and the speed is marginally better. WPE would always throw up errors - 

      Faulting application fmswpc.exe, faulting module PHP5isapi.dll. 

      This seems to have been solved. I hope filemaker comes out with an update soon to fix these issues.

       

      Upgrading from 5.2.6 also means Filemaker needs to change some of their underlying PHP code.

      Errors appear similar to the following "Only variable references should be returned by reference in ..." ( name of file which has the error), in my case a filemaker supplied file called LayoutImpl.php.

       

      Notices appear on screen with debugging on to let you know about this. Luckily you can just ignore those for the moment, and everything works fine. I could modify this file to fix the error but maybe this is something Filemaker needs to do as a bug fix? Having said this I am far from a PHP guru,  so it may be something I am doing wrong with my code.

       

      From my point of view, the server is still flaky, but much improved with the PHP upgrade.

      Filemaker and PHP is a great solution to many problems. Would love Filemaker to put more effort into PHP as this is a very popular development language.

       

      Users running advanced server under OS X probably have none of these issues.

       

      Cheers 

        • 1. Re: PHP upgrade for Advanced Server 10
          FluffyBear
             On the OSX side, PHP wrap the XML output from filemaker.  I created a custom API to work with the XML output from FMS directly for things like searching and ordering.  It reduce the per IO time from about 1.5 to 0.3 seconds per single request.  The PHP API provided by FileMaker does a LOTS of extra processing for the layout description data.  That's why you're running into resource limits issues.  If you want to use PHP with FM, either look into the ODBC driver, or write your own API.  You'll notice very significant performance increases.