Fast and efficient calculations

Need help Database
1

Hi everyone
I am trying to implement a simple web app. It should be able to calculate the amount of raw materials required to produce goods based on received orders. So, I have to go through some db tables, sum and multiply values.

But now my calculations are slow (even for a few records in db). I am not sure if it is because of poor bubble performance or because of low efficiency of my workflows
Do you folks implement such things on bubble? Maybe you have some tips/links on how to do calculations properly (now I am mostly using schedule workflow API on a list feature)

2

It will remain slow. I have the same issue and investigated the issue. Everybody dealing with hundreds or more database changes will see api workflow runs of minutes if not hours. Factor 100 till 1000 slower compared to AWS or Azure like setups.