100x Faster – Flight Testing FileMaker 13 Perform Script on Server – Part I | the beezwax buzz
100 TO 200 TIMES FASTER, with greater speed gains for remote clients. When properly implemented, Perform Script on Server (PSoS) can deliver incredible speed boosts. There are some caveats, however. You can’t just slap PSoS in a script–you have to provide the proper context and found set, among other things. Read Vince Monanno’s (Beezwax) in-depth guide to using PSoS:
Total time to run all the tests was 729 seconds. This was a typical FileMaker database, using only Perform Script for scripts. Compare this with the Perform Script on Server results, testing both wait and don’t waitoptions which both clock in at about 7 seconds.
If you move the FileMaker client to the East coast, some 2,492 miles from the server, we are looking at 1,398 seconds or 23 minutes using traditional Perform Script … and PSoS still clocks in at 7 seconds for both options.
Now it’s nearly 200x faster!
Finally, when you connect from as far away as Switzerland ( almost 6,000 miles )…. Those poor souls have to wait 46 minutes as opposed to (once again!) 7 seconds for Perform Script on Server.
Almost 400x faster!
400X faster! You could call that significant. Study the whole thing.
100x Faster – Flight Testing FileMaker 13 Perform Script on Server – Part I | the beezwax buzz.