Earlier today, I found myself quickly optimizing a Make scenario. It’s a great feeling to go from 9 operations per leave record to 2.
While the reductions here are small, 300 to 50 per scenario run, the techniques of reducing the usage of search record and set variable modules apply in more complex scenarios, too.
In a larger scenario, applying similar techniques, operations went from 15,000 daily to barely 4,000, and in another, from 400 per run to 7.
A reminder out of this optimization work is that effective isn’t efficient.
A walk-through of the changes
Try some of these techniques out yourself: blueprint.json (60.0 KB)
Setup the lookup array
Use the lookup array
Warning: I’ve an Enterprise account with access to custom functions. Therefore my jsonParse would be replaced by a JSON module to finish creating the lookup array.
Likewise, for the usage of jsonStringify just replace the formula with double quotes around the variable, like "bob".