Hello friends ! I have recently started getting rid of all the virtual columns i could in my apps, sparing only the ones having ref_row expressions, and replacing the rest with workflows that would recalculate the columns i need to recalculate only when it is needed, that worked great at first, until…
It became slow
Or at least slow enough to take more time than a sync does, so for example if an user made a change to a child row, a workflow would trigger an action that updates the value of a column in the parent row, but if he syncs manually after the change, the value is not updated.
That gives the impression to the user that the app is broken, since he synced a change and he’s still seeing an old value in the parent table, he won’t see the new value until he syncs again, which is problematic.
so here are the questions:
- How can i improve workflow performance?
- Has anyone experienced what i have described above?
- Do i have to apologize to my former virtual columns and beg them to come back to my app?
- Do i have to choose between the virtual columns murdering my sync times or my workflows killing the user experience?
BONUS QUESTION: Would a webhook do better in this use case?