Hello! Have a question that would be great to get some ideas on. I have a table that has some really complex calculations (it uses other tables, queries data over a long time range, conditional filtering, etc). From using the calculations analysis, I can see that specific column/formula is taking a long time.
This is what my options look like moving forward:
- optimize the formula (take advantage of indexes, not sure what else)
- perform “one-time” calculations that store the result in this table, versus a live formula
Any thoughts on how I could go about accomplishing this? Does option 1 or 2 make more sense, and how could I trigger an event like option 2 periodically?