3 Replies Latest reply on Jul 7, 2016 3:41 AM by wimdecorte

    FM Training Series: advantages using PSOS

    planteg

      Hi,

       

      in both Advanced for FileMaker 14 and Advanced for FileMaker 15, there is an advantage in using PSOS that I can't understand:

       

      Some cases have to do with improving the performance of a system in some way:

       

      Periodic updates of calculated values, such as inventory quantity-on-hand or student grade point average, because searching on stored, updated values is likely to work much faster than searching on unstored calculation field data.

       

      Searching on stored values will always be faster than searching on unstored values, it has nothing to where the script executed . Is there something I don't get ?

       

      Thanks

        • 1. Re: FM Training Series: advantages using PSOS
          databuzz

          I think the idea here is that you can have a process, e.g. a nightly update or batch update, that populates a stored field with it's unstirred equivalent. Performing this over the LAN/WAN is much slower when using PSOS.

           

          Users would search on the stored/indexed value which is populated via a PSOS as necessary.

          • 2. Re: FM Training Series: advantages using PSOS
            jrenfrew

            It's also the asynchronous nature of PSOS.

             

            Go to a little used part of the system. Trigger an update script which will go and touch all records. You don want to wait for that to finish before you can move on. Enter PSOS with the Wait For It To Finish button untucked. You can carry on, it does its work, but on demand, rather than writing a schedule for it - and you don't necessarily want the client anywhere near that.

            • 3. Re: FM Training Series: advantages using PSOS
              wimdecorte

              planteg wrote:

               

               

              Searching on stored values will always be faster than searching on unstored values, it has nothing to where the script executed . Is there something I don't get ?

               

               

               

              The text makes an implicit jump to the conclusion; what they are trying to say is that a PSoS script can be fired from a client to update those stored values faster or even without making the client wait for the script to finish, and at the same time - when the script is done - make the system behave faster because everyone can work with the stored values.

              2 of 2 people found this helpful