0

Speed up a script using Local Binding

I wanted to check my stock position going forward for the next 100 days so I created a table of days and took the daily demand out of stock each day and added in any forward contracts on the day they were due in to give me a graph

The red line is my stock with green and blue my Min / Max levels. The problem was that the script was taking a minute or so to run. Do as server didn't help (another story) but I addressed the problem by changing the Binding setting for my fields to Per record in memory (Browser). The script now only takes a second to run!

 

It's only suitable when you don't need to keep the field values from session to session.

Regards John

PS The Global variable in memory(Browser) is also useful in dashboards etc.

1 reply

null
    • Mel_Charles
    • 1 yr ago
    • Reported - view

    Good observation John 🙂

    useful to know

Content aside

  • 1 yr agoLast active
  • 1Replies
  • 113Views
  • 2 Following