2 Replies Latest reply on Nov 4, 2013 5:29 AM by mikebeargie

    Web Publishing Engine maxes out on one script in IWP

    HarveyMcArthur

      We are running several IWP hosted databases using FMSA 9.0.3 on a quad core Xeon. This is in a virtual envoronment using VMWare. Typically we have 4-5 simultaneous users accessing the databases from their browsers via the internet.

       

      A couple of the databases have report scripts that handle a lot of data and can take 20-30 seconds to run. When someone runs one of those reports, the CPU usage of the Web Publishing Engine shoots well over 100% and people using other databases get hung up until the report script in the first database finishes. Very annoying, of course. Is this expected behavior for FileMaker Server Advanced? Given that it is supposed to handle up to 100 IWP sessions simultaneously, shouldn't the WPE continue to process other users requests while running the report script from the first database?

       

      Any suggestions or reports of similar experiences would be much appreciated.

       

      Harvey McArthur

        • 1. Re: Web Publishing Engine maxes out on one script in IWP

          I've seen the same experience. Our typical daily access is 35-40 simultaneous, and most of their access is limited to entry and simple reporting. IWP has no CPU problems in this situation.

           

          When I have allowed reports or screens to sort through large record sets, I noticed the same thing you have -- it's like there's room for one CPU that pegs at 100% or more, and all other wait.

           

          My observation is that FileMaker users get the multi-CPU or multi-core goodness, while IWP does not.

          • 2. Re: Web Publishing Engine maxes out on one script in IWP
            mikebeargie

            IWP as a general feature I think is on it's way out (given the chatting happening about version 13 on the boards), so support from FM is going to remain limited.

             

            If you want away around the performance limitation, take a look at 360works remotescripter. It allows you to run a "robot" machine to generate reports that you store in container fields for your IWP users to access, this is usually quicker then trying to do the script directly via IWP since it doesn't use the web publishing engine, but it requires a dedicated machine (can be VM), the plugin, and another copy of FMpro.

             

            "Given that it is supposed to handle up to 100 IWP sessions simultaneously, shouldn't the WPE continue to process other users requests while running the report script from the first database?"

             

            Well, yes and no. Session based connections are different from actual data requests. From what I've seen it's still transactional, meaning requests for running a script, loading data, drawing views, etc.. are queued and handled in the order they are received. This is how FM12 can run incremental backups, and such, without the databases being suspended temporarily.

             

            Also, version 9 is over six years old now. I would highly consider upgrading. At least FMS12 is designed for 64-bit processing.