3 Replies Latest reply on Oct 8, 2012 10:19 AM by taylorsharpe

    Running PHP app - Two Machine Deployment - Very Slow!

      We promoted a PHP FMP 11 app from our development server running on a 4g iMac to a two Machine Deployment Windows 2008 Server Environment which is running in a VM environment with 2 gigs of memory for each server. Our app had been running successfully in this environment until we added additional features that update portal records, and print pdfs. Now the saves and prints time out in the Windows environment, even though they run fine on our development server. Obivously we should configure the VM machines with more memory. We are also looking at optimizing the php code for updating and adding child table records and using streamlined layouts. We also noticed in the stats the peak Elapsed Time & Wait Tiime calls were 9384615 & 7736113 respectively. Another post on this forum talked about taking a look at network latencies. Not sure how to do this.


      Are there any other considerations we need to look at to improve perfomance in the Windows environment?


      Any suggestions welcomed.



        • 1. Re: Running PHP app - Two Machine Deployment - Very Slow!

          Network latency will be minimized if you're running the two virtual machines in the same virtual system or are at least on the same switch.  I am assuming these two machines are not in different locations or trying to connect to each other over the internet.  And you obviously know about the memory needing increased. 


          By the way, the FM 12 PHP API is ***MUCH**** faster than the 11 one, which is something to think about potential upgrades.  But there are other things in 12 that are slower. 

          • 2. Re: Running PHP app - Two Machine Deployment - Very Slow!

            Thanks for the response. Is there any docs that address the FM 12 PHP API performance increases? Also after 4gig how much more benefit does one get from 8gig and so on. We have streamlined the layouts and updated directly into child tables instead of portals and that has helped significantly. The other option would be I presume to call fm scripts from php t o handle the updating.

            • 3. Re: Running PHP app - Two Machine Deployment - Very Slow!

              I am only aware of personal experience, but was told by someone at Devcon that it had to do wit the Server now being a 64 bit application.  Speaking of that, the 4 Gig of 32 bit applications no longer holds FileMaker back and you're able to assign up to half of the machines RAM to FileMaker Server.  So, yes, there is a FileMaker benefit to having more than 4 Gigs of RAM now whereas in previous versions, there was no benefit.